Check condition by group

[HarshaK]

Hello,

I have data which looks similar to below, I want to create a field to identify if any Sub-group (M1,M2...) within Master Group(A,B..) has a value "3" in the Indi Type Column.

I would like to have a new column Result and data values like below

	Master Group	Sub Group	Indi Type	Result
	A	M1	1	Y
	A	M2	1	Y
	A	M3	1	N
	A	M3	2
	A	M3	2
	A	M3	3
	A	M4	1	N
	A	M4	2
	A	M4	2
	A	M4	3
	A	M4	3
	B	M5	4	Y
	B	M6	4	Y
	B	M7	3	N
	B	M7	4

[fmvizcaino · Accepted solution]

Hi @HarshaK ,

I'm attaching an example showing how to do it.

Take a look and let me know if this works for you.

Best,

Fernando Vizcaino

[jyurkovich · Accepted solution]

I went by your description and not the example 'Result' column, which did not line up with your description.

[HarshaK]

Thanks for your response. Your solution works but is it possible to just show the value once for each group like below.

Master Group	Sub Group	Indi Type	Result	Result Needed
A	M1	1	N	N
A	M2	1	N	N
A	M3	1	Y	Y
A	M3	2	Y
A	M3	2	Y
A	M3	3	Y
A	M4	1	Y	Y
A	M4	2	Y
A	M4	2	Y
A	M4	3	Y
A	M4	3	Y
B	M5	4	N	N
B	M6	4	N	N
B	M7	3	Y	Y
B	M7	4	Y

[fmvizcaino]

Hi @HarshaK ,

My solution is right above and it is exactly as you requested.

Please check that out 🙂

Best,

Fernando Vizcaino

[HarshaK]

Thanks for your response, I am still testing this solution with my data set. I will let you know here how it goes. 

[HarshaK]

Hi,

I was able to use this solution as well. Thanks for your time and expertise.