We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
17 - Castor
17 - Castor

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
20 - Arcturus

@Tommy23 can you provide the expected result as well?

FreeRangeDingo
11 - Bolide
11 - Bolide

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
17 - Castor
17 - Castor

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