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,
LOCATION | TRANSACTION | PROVIDER | CUSTOMER | ITEM | CATEGORY | TRX DATE | DAYS SUPPLY | END DATE |
A1 | TRX84983 | PROV1234 | CUST32521 | ITEM-1 | A | 3/5/2019 | 30 | 4/3/2019 |
A1 | TRX33595 | PROV1234 | CUST32521 | ITEM-2 | A | 3/5/2019 | 30 | 4/3/2019 |
A2 | TRX54781 | PROV1234 | CUST23689 | ITEM-3 | B | 1/26/2020 | 30 | 2/24/2020 |
A3 | TRX92743 | PROV1234 | CUST48348 | ITEM-3 | B | 9/13/2018 | 18 | 9/30/2018 |
A3 | TRX17646 | PROV1234 | CUST48348 | ITEM-3 | B | 10/2/2018 | 30 | 10/31/2018 |
A3 | TRX49808 | PROV1234 | CUST48348 | ITEM-3 | B | 11/6/2018 | 30 | 12/5/2018 |
A3 | TRX57609 | PROV1234 | CUST48348 | ITEM-3 | B | 1/9/2019 | 15 | 1/23/2019 |
A4 | TRX96757 | PROV1234 | CUST19930 | ITEM-2 | A | 1/7/2019 | 25 | 1/31/2019 |
A4 | TRX91752 | PROV1234 | CUST19930 | ITEM-2 | A | 8/7/2019 | 30 | 9/5/2019 |
A4 | TRX46044 | PROV1234 | CUST19930 | ITEM-2 | A | 9/7/2019 | 30 | 10/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!!
Solved! Go to Solution.
Hi @sdpeacock,
I've designed some logic to identify customers with multiple transactions running on overlapping days:
Thank you very much @Aaron_Harter !