converting number codes to a string

[kreemnadeem]

Hello,

I am new to alteryx and my first new project contains data that has number codes that signifies certain string.

For example, under the column for race - 100 means "white" and i would like to replace all the numbers with text like white and hispanic, etc.

can someone help me with this part.

[LordNeilLord · Accepted solution]

Hey @kreemnadeem

I'd create a simple text input that contains a list of your codes and the strings you want to replace with i.e

Value text
100 Hispanic

And then use the join tool to match the values

Neil