topic Table Subtraction - where items not exist in QlikView

Table Subtraction - where items not exist

engishfaque — Sun, 01 Mar 2015 17:10:36 GMT

Dear All,

I have two tables called Table A and Table B or vice versa. And I have to subtract items and find unique items from Table B from both tables such as given below tables.

Table A

Itmes

ADF-JPS-001

ADF-JPS-001-ZZ0

ADF-JPS-001-ZZ1

Table B

Itmes

ADF-JPS-001

ADF-JPS-001-ZZ0

ADF-JPS-001-ZZ1

NR-87913

NI-R6501-ZZ8

Required output:

Itmes

NR-87913

NI-R6501-ZZ8

Kind regards,

Ishfaque Ahmed

Re: Table Subtraction - where items not exist

MK_QSL — Sun, 01 Mar 2015 17:13:22 GMT

T1:

Load * From Table1;

NoConcatenate:

T2:

Load * From Table2 where not exists(Items);

Drop Table T1;