Group BY

suby

Hello

Here i have 3 columns out of which Column C1 is populated with Yes or no based on certain conditions using Sub Category field.

What I'm expecting is i need another new column where if any of the C1 has got one 'Yes' then i want to classify the category as 'Yes' in my new column.

GROUPBY.yxmd

atcodedog05

Hi @suby 

Here is how you can do it.

Workflow:

1. Since we want to fill the whole category "Yes" is one of the C1 is "Yes". I am using summarize groupby category, max of C1 (Max gives highest descending value here Yes is higher than No)

2. Use join tool to join by category and C1 Fill column.

Hope this helps 🙂

GROUPBY.yxmd