topic How to compare two tables in App Development

How to compare two tables

ramkrishna86 — Thu, 02 Mar 2017 07:53:57 GMT

Hi,

Can anyone please help how to compare two table in qlik and only load not matching rows as shown in below table.

Table1:

Table2:

Desired Result:

Table3:

Thanks,

Ram Krishna

ali_hijazi — Thu, 02 Mar 2017 08:24:15 GMT

you need to create a key in both tables:

in table1 Load A, B,C, A & '|' & B & '|' & C as Key1

in table2 NoConcatenate Load A,B,C, A & '|' & B & '|' & C as Key2

finally:

Table3:

noConcatenate

load A,B,C

resident table1 where not exists(Key2,Key1);

drop tables Table1, Table2