Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Update row value based on another row

Ashwin1
7 - Meteor

Hi All,

 

For a distinct ID, if i find DWF as 'Y' for any of the PR then i need to update the column DWF for all the PR to have the value as 'Y'. 

 

AlteryxUpdate.PNG

 

 

Guess it should be done using multi row formula. But i am not getting the formula right.. 

 

Any help will be useful. 

 

Thanks in advance

Ashwin.

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @Ashwin1I have mocked up a workflow which I think answers your question. Let me know what you think?

MichalM
Alteryx
Alteryx

@Ashwin1 

 

I'd approach it differently. Using the Summarize tool I'd see all the unique DWF's per ID and then I'd filter out just the ID's with Y. I'd then use the Join tool to append these followed by Formula to replace the value where necessary. Example attached.

 

dwf.png

Ashwin1
7 - Meteor

HI  

           Thanks for your reply.Na i don't want to change the PR but want to change the DWF to Y for all the PR. Using your logic i got it working..

 

Thanks

Ashing

AndrewS
11 - Bolide

Hi, another option is to filter out and join back on the ID and rename.

Labels