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

Alteryx designer Discussions

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

Standardizing Data

Highlighted
Meteor

Hi Guys,

 

I have a "Color" column in the workflow 

Color 
red
"blue"
YellOW
[Black]
yellowish.green

 

I would like to standard all the data of Color Column following this Excel Column "Color Name"

Color Name
Red
Blue
Yellow
Black
Yellowish Green 

 

So i would like my outcome to be like this 

Color
Red
Blue
Yellow
Black
Yellowish Green 

 

*I have tried using the formula using IF Contain, it works but imagine if i have thousands of data and using formula seems crazy.

Thank You

Alteryx
Alteryx

I would suggest trying the Fuzzy Match Tool.   Given the small number of colors and that the spellings are all different from each other, it should be fairly robust.

Regards,
Stephen Ruhl
Customer Support Engineer

Labels