Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

Assigning a Status when ID is duplicated and multiple condition in another column

tf05
7 - Meteor

When a duplicate ID is found I am looking to add a new column to indicate if the status is the latest one or not. I need to keep all the data in the workflow as I will be reporting on the other statuses later on.

 

Input and desired output attached.

 

Any suggestion much appreciated.

 

Thanks

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @tf05 - I believe this should do the trick! Let me know how you get on.

 

DataNath_0-1652951283196.png

 

binuacs
21 - Polaris

@tf05 one way of doing this

 

binuacs_0-1652951398747.png

 

Labels
Top Solution Authors