Discussion board where members can learn more about Qlik Sense App Development and Usage.
Can anyone please help how to compare two table in qlik and only load not matching rows as shown in below table.
Go to 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
resident table1 where not exists(Key2,Key1);
drop tables Table1, Table2