Missed records from one row when compared with another row

Sreee — Wed, 22 Jul 2020 02:15:03 GMT

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.

Re: Missed records from one row when compared with another row

gireesh1216 — Wed, 22 Jul 2020 12:48:47 GMT

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;

topic Missed records from one row when compared with another row in Connectivity & Data Prep

Missed records from one row when compared with another row

Re: Missed records from one row when compared with another row