Discussion Board for collaboration on QlikView Scripting.
Have these two tables:
tab1:LOAD * INLINE [ F1, F2 A, 1 B, 2 C, 3 D, 4];
tab2:LOAD * INLINE [ F3, F4 A, AA B, BB C, CC E, EE];
Now I want to know how to use Where not exists() and resident load to get a new table containing this data:
I know how to solve this by using mapping load, but I want to understand the Exists() function.
Go to Solution.
Try this script
LOAD * INLINE [
WHERE Not Exists(F1, F3);
Hope it helps you.
Try the below code
LOAD F1 as F3, F4 Where Not Exists(F1);
LOAD F3 as F1 , F4
DROP Table tab2;
If you add the where not exists clause to the second load you'll get only E,EE in tab2:
Where not Exists(F1,F3) ;
Thank you for all answers.
All three solutions works, but I found Jagans solution most elegant, easy to grasp and also easiest to implement into my much more complicated reality... :-)
Thanks It helps me also.
Could you please explain how this can be achieved by using apply map??
Can you please tell me whether we can get the same result using apply map.