Organizing a column into a new column with custom groups

[ScottyD1990]

Hello all i am trying to group a column of data into a new column to categorize into bigger buckets. Please see the below sample of the data were for example i would like anything with TDC in the title be put into a group called TDC, or anything with Alteryx in the title go to a group called Data Analytics. I have a lot of different rules i would like to add if possible. 

Thank you in advance for the help!

[IraWatt · Accepted solution]

Hey @ScottyD1990,

I would recommend the find and replace tool. It will let you give it a list of values to find and what bucket you would like to go in:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[ScottyD1990]

Thank you! i appreciate the thelp!

[IraWatt]

No worries @ScottyD1990 😄