Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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).

MayilVahanan

Hi

Try like this

Load A as B;

Load * inline

[

A

10

20

];

Preceding load or resident load are the way

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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.