topic Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT in QlikView

Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

Thu, 06 Feb 2014 16:02:56 GMT

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;

Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

Anonymous — Thu, 06 Feb 2014 16:07:08 GMT

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)

Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

maxgro — Thu, 06 Feb 2014 16:08:44 GMT

RESIDENT, from online help

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

KEEP

Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

maxgro — Thu, 06 Feb 2014 16:09:30 GMT

image is from here

Qlikview en Español: Esquema Keep

Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

Thu, 06 Feb 2014 16:20:48 GMT

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.

Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

Thu, 06 Feb 2014 16:29:17 GMT

Thanks Michael. That was helpful.

Re: Confusion on RIGHT and LEFT KEEP, LOAD DISTINCT and RESIDENT

Thu, 06 Feb 2014 16:32:32 GMT

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