Hi guys, can someone give me a tip regarding how to change the "eleven" string to an int 11 please, thanks a lot.
😁
Solved! Go to 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
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!
Thanks a lot for the workflow
Thank you very much for the help. Got it
Thanks Chris