Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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;