SOLVED
Prevent data transformation
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
srk0609
8 - Asteroid
‎07-01-2022
12:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
3 REPLIES 3
apathetichell
19 - Altair
‎07-01-2022
12:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎07-01-2022
12:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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], ",","")
‎07-01-2022
12:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @kathleenmonks it worked