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

Hey @Tommy23,

What would you expect in the new column, would all rows with ID 1 and ID 2 have "yes" in them for example?

Tommy23
7 - Meteor

Yes this will be great @IraWatt 

Tommy23
7 - Meteor

Thanks again :) @IraWatt 

binuacs
17 - Castor

@Tommy23 can you provide the expected result as well?

FreeRangeDingo
10 - Fireball
10 - Fireball

Curious what others think, but my thought is that you would need to build a macro that takes one row and then compares it to all other rows. Also, I would make sure that your ID field is actually an ID and doesn't have duplicates.

IraWatt
16 - Nebula

Hey @Tommy23,

Is this the output your looking for?

IraWatt_0-1657035697111.png

Its yes if it covers or is being covered by another ID. I can change it to only look for ID's which are covered.

Any questions or issues please ask :)
HTH!
Ira

 

Tommy23
7 - Meteor

Hello I would like to have a column where "Yes" is wrote on the two or multiple row that have a period combine. @binuacs   

 

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

 

@FreeRangeDingo   ID is not an ID it is like a name or something it is not unique sorry for this misunderstand

Tommy23
7 - Meteor

Hello thanks for this,

 

I would like to be Yes if it is covered only by a period on the same ID, is what you did?

 

or you did "Its yes if it covers or is being covered by another ID"

@IraWatt 

Tommy23
7 - Meteor

ID is just not unique it is like a name or something @IraWatt 

Labels