Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Overlapping Orders

Highlighted
6 - Meteoroid

Alteryx users, I'm working on a project and need some help.

 

I looking at a set of order information in the format listed below. I am attempting to identify which customers had overlapping orders and how long those orders overlapped each other in days. For example, in the sample shown below, CUST32521 had 2 overlapping orders and they overlapped for 30 days,  

 

LOCATIONTRANSACTIONPROVIDERCUSTOMERITEMCATEGORYTRX DATEDAYS SUPPLYEND DATE
A1TRX84983PROV1234CUST32521ITEM-1A3/5/2019304/3/2019
A1TRX33595PROV1234CUST32521ITEM-2A3/5/2019304/3/2019
A2TRX54781PROV1234CUST23689ITEM-3B1/26/2020302/24/2020
A3TRX92743PROV1234CUST48348ITEM-3B9/13/2018189/30/2018
A3TRX17646PROV1234CUST48348ITEM-3B10/2/20183010/31/2018
A3TRX49808PROV1234CUST48348ITEM-3B11/6/20183012/5/2018
A3TRX57609PROV1234CUST48348ITEM-3B1/9/2019151/23/2019
A4TRX96757PROV1234CUST19930ITEM-2A1/7/2019251/31/2019
A4TRX91752PROV1234CUST19930ITEM-2A8/7/2019309/5/2019
A4TRX46044PROV1234CUST19930ITEM-2A9/7/20193010/6/2019

 

I've attached a larger data set with more variance for testing and proof of concept. I appreciate any assistance you can offer. 

 

Thank you!!

Highlighted
Alteryx Certified Partner

Hi @sdpeacock,

 

I've designed some logic to identify customers with multiple transactions running on overlapping days: 

1.PNG 

6 - Meteoroid

Thank you very much @Aaron_Harter ! 

Labels