Assigning a flag to a group if a specific value is contained within

[golfromeo]

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!

[JosephSerpis · Accepted solution]

Hi @golfromeo I mocked up a workflow that produces the output you describe. Let me know what you think?

[rituraj963 · Accepted solution]

Hi @golfromeo 

Let me know if this solution works for you.

[golfromeo]

@JosephSerpis This worked, thanks for your help!

[golfromeo]

@rituraj963 This solution also works, thanks very much!