Joining two files to find multiple matches

Ok, Attached is one file, but the data for “both” files is in there. I also put in there what the ideal outcome would be.

The scenario is I have dataset 1 with every scheduled shift from a scheduling system for an employee for a certain timeframe. Dataset 2 has just those shifts that were picked up via our open shift management tool. Im trying to add datapoints from the bottom dataset, to the top dataset so I then can do some “if” statements and look for outliers where the shift that was picked up doesnt match the shift that was in the scheduling system.
SCHEDULE MATCH.csv (710 Bytes)

Use Concat Cols to create a key column based on employee id and shift date and time. Then use that for the Join. Remove Cols the extra columns and Sort as desired.


shifts.transform (4.1 KB)