Update row value based on another row

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.

Developer

Developer Tools

Accepted answers

JosephSerpis

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

Update_Row_200819.yxmd

All comments

JosephSerpis

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

Update_Row_200819.yxmd

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.

dwf.yxmd

Ashwin1

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.

joinID.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703