Dear Alteryx Community Members,
I hope that a kind soul could help me out with a piece of advice, as it seems that I have gotten myself into deep waters. I have used Alteryx for 3 months now.
I need to figure out how to solve a project like this:
Scenario: An employee scans the barcode of a bus stop before getting on a bus. The barcode scanner also registers the GPS location, number of the bus line, the employee ID, trip ID, date and timestamp. When the employee gets off the bus, he scans the barcode of the bus stop at the destination.
The two barcode scans that are registered come in two separate files, and I need to join these data in pairs, giving that we should always have a set consisting of data from departure bus stop and data from arrival bus stop.
File #1 – Departure: Getting on the bus
Employee ID, ride ID, gps location, bus route number, bus number, type=”departure”, date, timestamp
File #2 – Arrival: Getting off the bus
Employee ID, ride ID, gps location, type=”arrival”, date, timestamp
I need to join on Employee ID, trip ID and date. The employee enters the employee ID and trip ID manually. So this could lead to wrong numbers, which I need to deal with.
The timestamp of type=”departure” should always precede the timestamp of type=“arrival”.
In case of more matches in File #2 (in case the employee enters duplicate trip IDs), how can I join with just the first match?
Any advice, links or suggestions on how to deal with this are most welcome.
Best regards,
Dorte
