topic Data Model Doubts..... in QlikView

Data Model Doubts.....

subbareddykm — Tue, 26 Jan 2016 08:21:07 GMT

Hi All i have some doubts in data model while creating Optimizing and using joins and keeps.

For Example :

Temp_Data:

Load * Inline [

Code

] ;

Data:

Code, Name,Region,Plant

From..... Where Exists(Code);

Doubts:

1.Here i m fetching data code=10 using Where Exists but how to apply left keep to this table.

2. I want to load Plant 100 to 250.How to load only 100 to 250 plants.

maxgro — Tue, 26 Jan 2016 19:29:31 GMT

1) I don't understand; left keep from which tables? and what's the result you want to achieve?

Where Exists(Code)

and Plant > 100 and Plant < 250;

PradeepReddy — Wed, 27 Jan 2016 05:26:02 GMT

1) No need of Left Keep.

you are fetching the records from the source table, where the Code is available in Temp_Data. It carters your requirement.

2) Load * from Source where Exists(Code) and Plant > 100 and Plant < 250;

rajeshforqlikvi — Wed, 27 Jan 2016 05:32:19 GMT

Temp_Data:

Load * Inline [

Code

] ;

inner join

Data:

Code, Name,Region,Plant

From..... Where plant >= 100 and plant <=200;