Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

manishnarang
Contributor

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
Valued Contributor III

Re: RESIDENT table on top of RESIDENT table

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

8 Replies
omyahamburg
Contributor II

Re: RESIDENT table on top of RESIDENT table

Hi

Should be read

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

Joerg

sujeetsingh
Honored Contributor III

Re: RESIDENT table on top of RESIDENT table

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

Not applicable

Re: RESIDENT table on top of RESIDENT table

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

Re: RESIDENT table on top of RESIDENT table

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
Valued Contributor III

Re: RESIDENT table on top of RESIDENT table

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
Contributor

Re: RESIDENT table on top of RESIDENT table

you definitely gave a lead Snehal.. Thanks

manishnarang
Contributor

Re: RESIDENT table on top of RESIDENT table

Thanks Very Much Sir

manishnarang
Contributor

Re: RESIDENT table on top of RESIDENT table

Thanks Very Much Sir

Community Browser