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 · Accepted solution]

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!

[atcodedog05 · Accepted solution]

Hi @Biko 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos]

Hi @atcodedog05,

It looks like we think the same 😛 

[atcodedog05]

@Emil_Kos 

Yeah posted almost at the same time🙂 You did 10 secs before me soo close 😅😂

[atcodedog05]

Hi @Biko 

If both of our solution works. Please mark both of the posts as solution.

And feel free to ask more question if you need more help 🙂

[atcodedog05]

Happy to help 🙂 @Biko 

Cheers and Happy Analyzing 😀

[Emil_Kos]

Hi @Biko,

Thank you for marking our posts as a solution.

Good luck!