Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Data Model Doubts.....

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

For Example :

Temp_Data:

Load * Inline [

Code

10

] ;

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.

3 Replies
maxgro
MVP
MVP

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

2)

Where Exists(Code)

and Plant > 100 and Plant < 250;

PradeepReddy
Specialist II
Specialist II

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
Creator
Creator

Temp_Data:

Load * Inline [

Code

10

] ;

inner join 

Data:

Code, Name,Region,Plant

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