Solved: Re: Get unmatched records - Qlik Community

praveenkumar_s · ‎2018-01-03

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 · ‎2018-01-03

t2:

load id, id as filter, name from Table2.

output:

Load id, name from Table1

where not exists(filter,id);

View solution in original post

Clever_Anjos · ‎2018-01-03

t2:

load id, id as filter, name from Table2.

output:

Load id, name from Table1

where not exists(filter,id);

Anil_Babu_Samineni · ‎2018-01-03

Looks for Exists - script function ‒ QlikView

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-01-03

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

praveenkumar_s · ‎2018-01-03

It is also working correctly.thanks for your help.