Resident Table join to bring out Unique values

Tue, 09 Apr 2013 22:12:33 GMT

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

Re: Resident Table join to bring out Unique values

sushil353 — Wed, 10 Apr 2013 05:23:10 GMT

do inner join

Load *

resident tableA

inner join(tableA)

load*

resident tableB;

HTH

Sushil

topic Resident Table join to bring out Unique values in QlikView

Resident Table join to bring out Unique values

Re: Resident Table join to bring out Unique values