Hey guys,
I'm currently helping a friend out with a problem she is stuck on. I got stuck as well. I attached a representative sample of the data along with a proposed solution.
Her goal is to consolidate the data so that we can see the difference in their clock in/clock out times on the two different systems. An ideal solution is attached and shown below.
We pull in data from Truck Drivers from two different systems, XRS and Kronos. The data she is worried about are: name, date, clock in, clock out.
Currently there are 2 different tabs, XRS and Kronos representing the different sources. Not all names depicted in Kronos are in XRS, however all names in XRS are in Kronos. The third tab is the ideal solution page.
Please let me know if there are any questions.
Thank you guys in advance.
Capture.PNG
Bookmarks