Hello all,
Sorry if this is a basic question, but I couldn't find the answer after a lot of searching through the discussions!
I need to assign a Y/N flag to a category if it contains a specific value in another column. For example, if "ABC" is contained in the Supplier field for any of the companies, the flag should be Y for all the rows for that company. If there is no supplier ABC, then the flag should be N.
This is an example table for what I need:
Company | Supplier | Flag |
Company A | hhh | Y |
Company A | www | Y |
Company A | ABC | Y |
Company B | qqq | N |
Company B | hhh | N |
Company B | bbb | N |
Company C | aaa | N |
Company C | bbb | N |
Company C | qqq | N |
I hope I've explained this well enough and hope you can help.
Thank you!
Solved! Go to Solution.
Hi @golfromeo I mocked up a workflow that produces the output you describe. Let me know what you think?
@JosephSerpis This worked, thanks for your help!
@rituraj963 This solution also works, thanks very much!