Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Prevent data transformation

srk0609
8 - Asteroid

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.

srk0609_0-1656702681580.png

srk0609_1-1656702797222.png

 

 

3 REPLIES 3
apathetichell
19 - Altair

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
Alteryx
Alteryx

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
8 - Asteroid

Thank you @kathleenmonks it worked

Labels
Top Solution Authors