Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert Text to number

MB_Rocks
7 - Meteor

How to convert 

Coulm a Column b

zero         0%

one          1%

ten           10%

eighty        80%

 

in alteryx plse help huge data 

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @MB_Rocks,

Can do it like this:

IraWatt_0-1652875319670.png

 

MB_Rocks
7 - Meteor

How to convert text to numeric 

I have values as zero want to see as 0% 

Coulmn a to  Column b

zero             0%

one              1%   

ten              10%

eighty        80%

 

in alteryx plse help huge data 

DataNath
17 - Castor
17 - Castor

The only way I can think of doing this is with a lookup table like so:

 

DataNath_0-1652877427162.png

 

It's not ideal, but I don't know of any functions to turn written numbers into their digit counterparts. Hopefully somebody else can chime in if they do!

Labels
Top Solution Authors