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.
SOLVED

Status within multiple rows

Nandakishore
8 - Asteroid

Hi ,

 

I have this requiement where data contains ID and Status columns as shown  :

 

ID Status New Status 
ABCRP
DEFPP
GHIRR
ABCPP
DEFPP
ABCRP

 

ID contains multiple id's , few repeat with status . For example ID 'ABC' has status R and P . Now the requirement is , since ABC has R & P  , whenever there is P status for any ID , then even other status must be changed to P for the same id . The change need to stamped in new status column as show. 

 

Thanks.

2 REPLIES 2
dwstada
11 - Bolide

@Nandakishore here is a solution

 

Nandakishore.PNG

Nandakishore
8 - Asteroid

@dwstada 

 

thankyou  :)

Labels
Top Solution Authors