Update row value based on another row

[Ashwin1]

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

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.

[JosephSerpis · Accepted solution]

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

[MichalM]

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

[Ashwin1]

HI  

JS420,

           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]

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