Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Getting Begin and End Dates from a Grid

RBoyd
6 - Meteoroid

Hello, 

 

My data is organized with a unique code in the first column and then a date grid as below.

 

Code2023-03-092023-03-162023-03-232023-03-302023-04-062023-04-132023-04-202023-04-272023-05-04
123xxx xx   
456 xxx  xxx
789   xxx   
101xx xx xx 
102   xxx   
103xxxxx xx 

 

I would like to transform the data to give me the begin and end dates of each wave/iteration. There is not a need for more than 3 waves. I would like the data to look like this once complete.

 

CodeWave 1 StartWave 2 EndWave 2 StartWave 2 EndWave 3 StartWave 3 End
1232023-03-092023-03-232023-04-062023-04-13  
4562023-03-162023-03-302023-04-202023-05-04  
7892023-03-302023-04-13    
1012023-03-092023-03-162023-03-302023-04-062023-04-202023-04-27
1022023-03-302023-04-13    
1032023-03-092023-04-062023-04-202023-04-27  

 

Thank you for any assistance!

4 REPLIES 4
gautiergodard
13 - Pulsar

hey @RBoyd 

Would you be able to explain the concept of the "Waves" in your desired output.

I am not sure I follow how these are being derived. 

RBoyd
6 - Meteoroid

 

 

RBoyd
6 - Meteoroid

Absolutely. The X under each date signifies that that code is active for that week. So a wave would consist of consecutive weeks in which an X is present.  For instance, in the initial table i posted code 123 would have 2 waves as there is 2 strings of consecutive x's present.

 

Felipe_Ribeir0
16 - Nebula

Hi @RBoyd 

 

One way of doing this

 

Felipe_Ribeir0_0-1669842954087.png

 

Labels
Top Solution Authors