Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to edit preloaded inline table

Hi Experts,

Pls advice me Can I edit preloaded inline table & how ?

Thanks in advance.

Neeraj Kumar (NK)

3 Replies
MVP
MVP

Re: How to edit preloaded inline table

May be like:

InTab:

Load * Inline [

F1

1

2

3

4

5

];

Load F1,

          F1*100 As NewF1

Resident InTab Where F1>2 ; 

Basic idea is to use RESIDENT and use conditional load (like where clause, or any other expression in the field itself).

Re: How to edit preloaded inline table

Hi

Try like this

Load A as B;

Load * inline

[

A

10

20

];

Preceding load or resident load are the way

Not applicable

Re: How to edit preloaded inline table

You can directly edit in your inline table like below:

LOAD A, B, A*B AS C INLINE [

A, B

1, 3

4, 5

] ;

You can apply any load transformation in INLINE itself.

Community Browser