Alteryx Designer Discussions

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

Time between period for each ID

Tommy23
7 - Meteor

Hello I would like to have column that tell me if there is one period that are combine for each ID. (Juxtapose period)

 

Here a example of sample data ( this just an example , how to do it o it can work for various case)

IDBegin DateEnd date
128/01/202201/02/2022
101/01/202210/01/2022
205/01/202218/01/2022
319/02/202220/02/2022
418/01/202219/01/2022
406/01.202207/01/2022
402/03/202203/03/2022
125/01/202218/03/2022
206/01/202207/01/2022
314/01/202215/01/2022

 

 

For example here the ID 1 and 2 have period that are combine 

I hope I was clear thanks

 

Thanks :)

10 REPLIES 10
IraWatt
16 - Nebula

AAAhhh I think I get it @Tommy23. I adjusted my workflow which does seem to get your result:

IraWatt_1-1657036348474.png

 

 

Labels