topic Re: How to edit preloaded inline table in QlikView

How to edit preloaded inline table

Fri, 29 Nov 2013 06:20:24 GMT

Hi Experts,

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

Thanks in advance.

Neeraj Kumar (NK)

tresB — Fri, 29 Nov 2013 06:29:02 GMT

May be like:

InTab:

Load * Inline [

];

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 — Fri, 29 Nov 2013 07:31:45 GMT

Try like this

Load A as B;

Load * inline

[

];

Preceding load or resident load are the way

Fri, 29 Nov 2013 14:19:55 GMT

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.