Discussion board where members can get started with QlikView.
I have two seperate table table1 and table 2. i want to load the unmatched records from both table in load script as see the attachment below. Kindly share your knowledge.
load id, id as filter, name from Table2.
Load id, name from Table1
where not exists(filter,id);
View solution in original post
Looks for Exists - script function ‒ QlikView
Please see attached example using Where Not Exists(ID,ID)
It is also working correctly.thanks for your help.