Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

[#1]

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;

[Anonymous]

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]

RESIDENT, from online help

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

KEEP

[maxgro]

image is from here

Qlikview en Español: Esquema Keep

[#5]

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.

[#6]

Thanks Michael.  That was helpful.

[#7]

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