Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sreee
Contributor
Contributor

Missed records from one row when compared with another row

I have two tables (TableA & TableB) with some data in them. Both TableA and TableB have one unique column named ID. I just kept side by side in the excel for easy understanding. The ID fields in both of them have some common data and some missing data in them. I need to figure out a way to show which are missing in both of them into a different table on my qlik dashboard.

Please find the EXCEL attached sheet below to help you understand better. The result I'm expecting is in the excel sheet too.

Any help is greatly appreciated. Please. Thank you.

1 Reply
gireesh1216
Creator II
Creator II

Source1:

Load ID ,'Exist' as Flag1 from Source1;

Join

Load ID from Source2 where not exist(ID);

Source2:

Load ID,'Exist' as Flag2 from Source2;

Join

Load ID from Source1 where not exist(ID);

ABC:

Load *,1 AS Z resident Source1;

join

Load * ,1 as z resident Source 2;

drop tables Source1,source2;

Load ID,If(isnull(Flag1),'Miss',if(isnull(Flag2),'Miss','Exist')) as Flag_Miss resident ABC

Drop table ABC;