Question on converting to numeric data types

Question

Hello,

I have input the data from an excel sheet. By default, every value is in string data type. As I was trying to convert to int32 by using the select tool, Alteryx is not recognizing the comma for the value (For instance, 100,000 would output to 100). To solve that, I would have to use RegEx to remove comma in order to convert the string to int32. Would there by any better solution for that as that only convert one column?

Thanks!

MarqueeCrew · Answer

@ringocheng618

please use a multi field formula.  You may only be selecting one field, but you can change the data type to a numeric type.

replacechar( ) is the function that you'll want. "," gets replaced with "".

cheers,

mark

Qiu · Answer

@mot

Maybe you can change the user settings.

mot · Answer

Hi @ringocheng618,

You can use Data Cleansing tool and check Remove Punctuation. I hope this helps. Best.