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 | |||
Solved! Go to 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
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 |
Hi @HarshaK ,
My solution is right above and it is exactly as you requested.
Please check that out 🙂
Best,
Fernando Vizcaino
Thanks for your response, I am still testing this solution with my data set. I will let you know here how it goes.
Hi,
I was able to use this solution as well. Thanks for your time and expertise.