Quick and easy question for replacing a value

[DavidP07]

Hi guys, can someone give me a tip regarding how to change the "eleven" string to an int 11 please, thanks a lot.

😁

[ChrisTX · Accepted solution]

Use a Formula tool with the output data type set to INT16

IF [What is your age?] = "eleven" THEN 11

ELSE [What is your age?]

ENDIF

But the original column for [What is your age?] is not data type Integer because it has a value "eleven".

Here's the list of all Functions:  https://help.alteryx.com/current/en/designer/functions.html

Chris

[AndrewDMerrill · Accepted solution]

In the event that you have more such issues. Here is a workflow that generates a find and replace list of numbers in English up to "ninety nine" (99).

The problem is that you need a dictionary that does not exist built into Alteryx Designer. You'll have to get one from somewhere if you want to be able to change the words for numbers with their numeric counterpart. Hopefully, this dictionary helps (see attached workflow), but if "eleven" is your only issue, then a simple formula really is all that you need. And @ChrisTX - is absolutely correct!

[DavidP07]

Thanks a lot for the workflow

[DavidP07]

Thank you very much for the help. Got it

[DavidP07]

Thanks Chris