Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manishnarang
Partner - Creator
Partner - Creator

RESIDENT table on top of RESIDENT table

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

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

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

View solution in original post

8 Replies
omyahamburg
Creator II
Creator II

Hi

Should be read

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

Joerg

sujeetsingh
Master III
Master III

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

Not applicable

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
Creator II
Creator II

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
Specialist III
Specialist III

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
Partner - Creator
Partner - Creator
Author

you definitely gave a lead Snehal.. Thanks

manishnarang
Partner - Creator
Partner - Creator
Author

Thanks Very Much Sir

manishnarang
Partner - Creator
Partner - Creator
Author

Thanks Very Much Sir