Discussion Board for collaboration related to QlikView App Development.
Hi All i have some doubts in data model while creating Optimizing and using joins and keeps.
For Example :
Load * Inline [
From..... Where Exists(Code);
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.
1) I don't understand; left keep from which tables? and what's the result you want to achieve?
and Plant > 100 and Plant < 250;
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;
From..... Where plant >= 100 and plant <=200;