Check condition by group

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

Data Investigation

Accepted answers

fmvizcaino

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

2020-02-17 Check condition by group.yxmd

jyurkovich

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

check condition by group.yxmd

All comments

fmvizcaino

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

2020-02-17 Check condition by group.yxmd

jyurkovich

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

check condition by group.yxmd

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

HarshaK

Hi,

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703