topic Re: resident load in QlikView

resident load

Thu, 08 May 2014 04:49:36 GMT

hiiii,

i have a data loaded from inline .

i want to jst ask is it possible to generate table using resident load from data which is loaded inline

Re: resident load

Thu, 08 May 2014 04:53:23 GMT

yes it is possible.

table1:

load * inline

[

col1,col2

a,20

b,50

];

noconcatenate

table2:

load *

resident

table1;

Re: resident load

tresB — Thu, 08 May 2014 04:55:29 GMT

Yes. Like below:

Tab1:

Load * Inline

[ Field1, Field2

A, 10

B, 20

];

Tab2:

Load *, '1' as Dummy Resident Tab1;

Re: resident load

rajat2392 — Thu, 08 May 2014 04:56:34 GMT

Hi Akash,

Yes it is absolutely possible. You just have to give a table name to the inline table you are creating. As you can see below

Table1:

Load * Inline

[

Column1, Column2

......., ......

......., .....

];

NoConcatenate

New_Table:

Load *

Resident Table1;

Drop Table Table1;

This is how you can resident load from a inline table.

Re: resident load

Thu, 08 May 2014 05:01:51 GMT

@Rajat, your code won't work. This will simply concatenate the second load statement into the first table. It will never create the 'New_table' as the structure of this is similar to the existing table. You have to have a noconcatenate before the second load.

Thanks,

Ram

Re: resident load

rajat2392 — Thu, 08 May 2014 05:21:32 GMT

Hi Ram,

Thanx for the correction, I forgot to write it.