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
Solved! Go to 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!
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 😀👍
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 🙂