Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ramkrishna86
Not applicable

How to compare two tables

Hi,

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

Table1:

Table1.PNG

Table2:

Table2.PNG

Desired Result:

Table3:

Table3.PNG

Thanks,

Ram Krishna

1 Solution

Accepted Solutions
ali_hijazi
Not applicable

Re: How to compare two tables

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

I can walk on water when it freezes
1 Reply
ali_hijazi
Not applicable

Re: How to compare two tables

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

I can walk on water when it freezes