Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resident Table join to bring out Unique values

Hello:

Can any one help me with teh following solution I am looking for:

I have two resident tables A & B, and both have one field "Part", how can I join these two resident tables and bring out just the unique values from the

"Part" field, that is just want to see only values that is in table A and not in table B and vice versa.

Any help will be greatly appreciated.

thanks

Kumar

1 Reply
sushil353
Master II
Master II

do inner join

Load *

resident tableA

inner join(tableA)

load*

resident tableB;

HTH

Sushil