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.