I have two data sets one having employee Activity on each days and need to check if employee worked on holiday or not.
Example:
Table 1:-
Holidays Table:-
Expected output:
Tried using Left outer join but I got only limited output which is not included with null for all the days which are not matched.
Expecting a workflow solution.
Link to download inputs:- https://drive.google.com/drive/folders/1A8K67lRi1jmO2kexj8GQGbTQFMaLkgQe?usp=sharing
Thanks in advance!!
Solved! Go to Solution.
@PNC97
A bit different approach with @apathetichell and I have to do a DateTime formating to ensure the data consistency.
@PNC97- If you are planning on doing any additional date based calculations or you believe that data consistency may be an issue - transforming the dates into Alteryx date format as @Qiu does is key. My workflow is more of an illustration of how to use joins to get the information that you want - I would clarify that @Qiu 's is considerably more scalable.