Date reconciliation two way

Biko

Hi All, 

I have holiday dates database between two systems that I want to reconcile. I can join the table using the third column "USA Holiday". 

System A

2020-11-11	Veteran's Day	USA Holiday
2020-11-26	Thanksgiving	USA Holiday
2020-12-25	Christmas Day	USA Holiday
2021-01-01	New Year's Day	USA Holiday

System B

2020-11-11	Veteran's Day	USA Holiday
2020-11-25	Thanksgiving	USA Holiday
2020-12-25	Christmas Day	USA Holiday
2021-01-01	New Year's Day	USA Holiday

However how do I make it a two-way reconciliation whereby according to the above inputs, the outputs will be:

2020-11-25 = missing in System A

2020-11-26 = missing in System B

Emil_Kos

Hi @Biko,

I have joined the data on the date column to achieve the result:

Output:

If this is something helpful please mark as an answer.

Good Luck!

Date Recon.yxmd