Get unmatched records

[praveenkumar_s]

Hi frnds,

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.

[Clever_Anjos · Accepted solution]

t2:

load id, id as filter, name from Table2.

output:

Load id, name from Table1

where not exists(filter,id);

[Anil_Babu_Samineni]

Looks for Exists - script function ‒ QlikView

[Anonymous]

Please see attached example using Where Not Exists(ID,ID)

[praveenkumar_s]

It is also working correctly.thanks for your help.