Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

The below script has me confused.  Could anyone answer the following questions:

1) How do you know which table is left and which is right?

2) What does the statement RESIDENT [Main Data] do?

Thanks!

Temp_Aircraft_Type_Dim:

RIGHT KEEP ([Destination Airports])

LOAD DISTINCT

[%Destination Airport ID]

RESIDENT [Main Data];



DROP TABLE Temp_Destination_AirportID_Dim;

6 Replies
mov
Champion III
Champion III

1. the table loaded earlier (Destination Airports) is left, the table loaded later (Temp_Aircraft_Type_Dim) is right.

2. Loading data from the previously created (in the script) logical table (Main Data)


maxgro
MVP
MVP

RESIDENT, from online help

resident is used if data should be loaded from a previously loaded table

KEEP

keep.jpg

maxgro
MVP
MVP

Not applicable
Author

hi Alexander,

RESIDENT is key word means from RAM.

suppose we load the table example Employee and stored locally named as Emp.

then we want to reuse the fields  presented in the  Emp then we simply load from RESIDENT Emp instead of again going to getting from the Db or source .

Understanding Join, Keep and Concatenate

above link will help ful to u understanding keep,join and concatenate.

i hope it helps you.

regards

Mahesh T.

Not applicable
Author

Thanks Michael.  That was helpful.

Not applicable
Author

you are fine with answers can you please close the thread by correct answer and helpful etc.it will be helpful to other people as well.

regards

Mahesh T