Organizing a column into a new column with custom groups

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!

Data Example.xlsx

Datasets

Fuzzy Match

Data Investigation

Accepted answers

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

All comments

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

Thank you! i appreciate the thelp!

No worries @ScottyD1990 😄

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703