Prevent data transformation

[srk0609]

Hi,

I dont know why Alteryx is automatically converting only this values. 250,000 is getting converted to 250 other values are fine. Can anyone help? The values are changing after select tool.

[apathetichell]

what does it say for decimal separator in localization (options/user settings/edit user settings/localization tab)? If this is set up for comma, change it to period.

[kathleenmonks · Accepted solution]

Hi @srk0609 

This is happening because of the comma in "250,000" - when converting to a double, it is stopping at the first non-numeric character. To fix this, add a formula tool before the select with this formula: ReplaceChar([Quantity], ",","")

[srk0609 · Accepted solution]

Thank you @kathleenmonks it worked