Hi everyone,
I am working on a workflow that identifies overlapping shipments based on their pickup time window (early pickup date and late pickup date). Please see the attached file for more details.
I initially used a self-join but the workflow only paired up shipments instead of being able to find all (more than 1) overlapping shipments. What would be the best way to do this?
Thank you Alteryx community!
Solved! Go to Solution.
Thank you for your prompt response. The format I need looks something like this
Shipment ID | Overlapping Shipment 1 | Overlapping Shipment 2 | Overlapping Shipment 3 | Overlapping Shipment 4 | Overlap Window Start | Overlap Window End |
123 | 456 | 789 | (null) | (null) | 24-05-04 | 24-05-05 |
Thank you! This worked wonderfully.