Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Overlapping Orders

sdpeacock
7 - Meteor

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!!

2 REPLIES 2
Aaron_Harter
11 - Bolide

Hi @sdpeacock,

 

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

1.PNG 

sdpeacock
7 - Meteor

Thank you very much @Aaron_Harter ! 

Labels