topic Re: Resident Table join to bring out Unique values in QlikView

Resident Table join to bring out Unique values

Tue, 09 Apr 2013 21:32:09 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

Wed, 10 Apr 2013 15:46:15 GMT

Many thanks Mr.Neves for your time in explaining my query,

is there any possibility that part B & F can be isolated and

loaded into a resident table .

This is because part B is in Table A but not in Table B

and part F is in Table B but not in Table A

Thanks in advance for any help you can offer

Kumar Ramanujam

Senior Data Analyst

Victaulic Company of America

kramanujam@victaulic.com

Phone: + 610-559-3601

Cell: + 484-226-6510

Re: Resident Table join to bring out Unique values

Gysbert_Wassenaar — Wed, 10 Apr 2013 16:19:42 GMT

See attached example