Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;