RESIDENT table on top of RESIDENT table

[manishnarang]

Hi All,

Can we use RESIDENT table on top of another RESIDENT table?

I am trying to use as below and getting error "Tab2 is not found"

Tab1: LOAD * FROM [..\..\qv data\HistoricalData2.qvd] (qvd); Tab2: LOAD DISTINCT * RESIDENT Tab2; STORE Tab2 INTO [..\..\qv data\HistoricalData2.qvd] (qvd);

[omyahamburg]

Hi

Should be read

Tab2: LOAD DISTINCT * RESIDENT Tab1; STORE Tab2 INTO [..\..\qv data\HistoricalData2.qvd] (qvd);

Joerg

[sujeetsingh]

Sorry as till i know it seems impossible...but i didnt get u completely ?

[#4]

Hi Manish,

Yes,we can use RESIDENT on top of another RESIDENT table.

Please find the below example.

Eg: 

temp:

LOAD YF_FLAG,

          YF_YP

FROM D:\Examples\Qvds\YF.qvd (qvd);
Data:
LOAD  YF_FLAG AS YF1,

           YF_YP AS YF2

RESIDENT temp;

Data1:
LOAD  YF1 AS YF3,

YF2 AS YF4

RESIDENT Data;

Considering the above example,to use RESIDENT on top of another RESIDENT table,you need to rename the fields in the the Data1 table, or else qlikview identifies same field names and does AUTOCONCATENATE.

Hope this helps.

Regards,

Snehal Nabar

[omyahamburg]

You can load resident from an existing (previously loaded in script) table.

In your case, you have Tab1 loaded, so you can load resident from Tab1.

Tab2 you want to create, you cannot load resident from a non existing Tab.

[nagaiank · Accepted solution]

Try the following

Tab1:

LOAD * FROM [..\..\qv data\HistoricalData2.qvd] (qvd);

Tab2:

NoConcatenate

LOAD DISTINCT * RESIDENT Tab1;

STORE Tab2 INTO [..\..\qv data\HistoricalData2.qvd] (qvd);

[manishnarang]

you definitely gave a lead Snehal.. Thanks

[manishnarang]

Thanks Very Much Sir

[manishnarang]

Thanks Very Much Sir