Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
mov
Esteemed Contributor III

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

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)


Highlighted
MVP
MVP

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

RESIDENT, from online help

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

KEEP

keep.jpg

Highlighted
MVP
MVP

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

Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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

Thanks Michael.  That was helpful.

Highlighted
Not applicable

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

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