How to compare two tables

[ramkrishna86]

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 · Accepted solution]

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