Grouping few item under one name

[SH_94]

Hi Community,

I would like to ask how can i build the group as per the table below:Basically i would like to group certain item into one category and i not sure how can i do that in alteryx.

I have also attached excel working for your reference.

[atcodedog05 · Accepted solution]

Hi @SH_94 

You would need to have a lookup table for grouping.

Workflow:

Hope this helps : )