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.

[atcodedog05 · Accepted solution]

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 🙂

[shreyanshrathod · Accepted solution]

@suby ,

Not sure about your exact requirement, but this could help.

Regards,

Shreyansh Rathod

[suby]

Hi atcodedog05,

You're super hero thanks for your solution it works.

[suby]

Thanks for your solution it works.