Discussion board where members can get started with Qlik Sense.
I have the following two tables，
What I want to do is to match the content of table1 with the content of table2. If the content of table2 exists in table1, it is deleted in table1, and if it does not exist, the content of table2 is inserted into table1.
Thanks a lot!
You can use AutoNumberHash128 and Exists functions to check if the row occurs in both table.
Load *,AutoNumberHash128(A,B,C,D) as RowKey1 inline [
Load *,AutoNumberHash128(I, J, K, L) as RowKey2 inline [
LOAD A,B,C,D Resident Table1
WHERE NOT Exists(RowKey2,RowKey1);
LOAD I AS A, J AS B, K AS C, L AS D Resident Table2
WHERE NOT Exists(RowKey1,RowKey2);
DROP TABLES Table1,Table2;