Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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