Overlapping Time Windows

[AnhNguyen326]

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!

[Bobbyt23]

pending on what format you needed the output you could do something like this:

[AnhNguyen326]

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

[Bobbyt23 · Accepted solution]

It's probably not the cleanest macro but think this gives you what you wanted.

Will at least give you something to work with/tweak.👌

[AnhNguyen326]

Thank you! This worked wonderfully.