community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Grouping text values to a consistent names

Hello,

 

I am trying to group data in a column in to standardized labels. For example, in the following data set,i want to group Apple, Banana and Blueberries and similarly Wheat and Maize to Grains. I know I can use a series of IF OR and ELSEIFs, but i'm wondering if there's an easier way. My data has over 500,000 rows and over 65 categories that are all text. Is there a way to select only the "vegetables" and replace with the word "vegetables"?

 

Thanks, 
Megha

 

Apple
Banana
Carrot
Blueberries
Wheat 
Maize
Lamb
Highlighted
Quasar

Can you set up a lookup table with the 65 categories and then use it as an input to the Find Replace tool?

Labels