Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Identify type of joining

Colleagues, good day!

Simple question:

Script loads first table:

 

IdField1
1A
2A
3A
4A
5A
6A

Then i must load second table but only data for those Id which are not contain in first table:

Second:

 

IdField2
1B
2B
3B
4B
8B
9B

In result i must get only:

 

IdField2
8B
9B

Thanks.

14 Replies
Anonymous
Not applicable
Author

Thanks, dear.

sunny_talwar

Why is 5 included, but 1 or 2 not included in your final output?

Anonymous
Not applicable
Author

Sorry, it's my mistake:

Necessary result:

 

IdF1
13
2ed
3fd
4dfd
5fdf
7u
sunny_talwar

May be like this:

A:

LOAD Id,

          Field1,

          Id&Field1 as Check

FROM....

B:

NoConcatenate

LOAD Id,

          Field1

FROM ...

Where not Exists(Check, Id&Field1);

DROP Table A;

Anonymous
Not applicable
Author

Perfect!

Thanks!