String to numbers Multiple fields

Hello everyone,

I have a question on how to convert strings to numbers for my data. I attached a sample of the data I have(I included all types of strings I have in my file) and the desired outcome in the the secont sheet. I do not know if there is a simple way of doing this since I have hundreds of columns(for which the headers sometimes contain numbers that i don't want to change).

Could somone help me with this matter,

Thank you in advance

samplenumbers.xlsx

Workflow

Datasets

Data Investigation

Accepted answers

grossal

You can choose to select all and than deselect the Type-Column @davidgosselin.

AbhilashR

@davidgosselin - just to add a tiny detail to @grossal's most recent post, as long as you uncheck Type field and check the Dynamic or Unknown Fields option, all new columns in your dataset will be processed in the Multi-Field formula tool. The Dynamic or Unknown Fields option is our way of instructing Alteryx to process new fields being introduced in the source data.

All comments

grossal

HI @davidgosselin,

here is a way to do it:

Output:

You will notice that the first cell is different, but in my eyes your desired output was wrong, because E-4 will be cutoff with only two digits.

Workflow attached. Let me know if it helps.

Best

Alex

2020-03-29-converting-numbers.yxmd

davidgosselin

This workflow would do it but the problem with this one is that I have hundreds of columns I would not want to manually select each one of them, I would want it to be done without have to select them. Would there be a way to do it?

Thank you for your time Alex,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703