Discussion Board for collaboration on QlikView Scripting.
I have a big table with lot of columns with one key. For example 140,142,143,145,146 etc.
I have another table with the few keys for example 140,142.
Now I want to fetch all data from big table for only matching values for the above example 140 and 142 only.
Go to Solution.
There is Various ways
1)Load Table with few Keys then Use left join and load another table having lots of columns
2) use Exist()
1st load table having few Keys, then load 2nd table having lots of column and use where condition in that use Exist()
Let's say TableA with all values and TableB with less values:
Load * resident TableA;
Load * resident TableB;
in this way only elements from table B that are Presente in tableA will be shown
Let me know
Duplicate row Issue
or look for ApplyMap
post our data
You can try like this
First load the "second table contains 140,142".
Load * from big table;
Hope it helps