String to Number

[johnrexrima_19]

Hello,

In my workflow, my input file is in CSV format so the data types are all in a string. Will it be possible to convert string to a number(double). I am trying to do that but what happens is that it only picks up the numbers prior to the first comma of the Real Gain/Loss (Base) column (see example below).

Values in String format

Values in Double format

[Emil_Kos]

Hi @johnrexrima_19,

Use the data cleansing tool to remove punctuation from this field. Afterwards you will be able to change the data type without truncating data.

[atcodedog05]

Hi @johnrexrima_19 ,

take a look at AutoField tool.

https://help.alteryx.com/2018.2/AutoField.htm

If its in a certain format it will convert it to it.

Hope this helps.

[seinchyiwoo · Accepted solution]

Hi,

You would need to clean up the comma first (using formula) before you can convert them to double.

See attached workflow.

[johnrexrima_19]

Thank you all for your suggestions! Appreciate it! 

@seinchyiwoo  the formula tool works perfectly! Thanks so much!