Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Get unmatched records

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.

Snap.png

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Get unmatched records

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

4 Replies
Highlighted
Employee
Employee

Re: Get unmatched records

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

Highlighted

Re: Get unmatched records

Looks for Exists - script function ‒ QlikView

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: Get unmatched records

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

Highlighted
Creator II
Creator II

Re: Get unmatched records

It is also working correctly.thanks for your help.