In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to i convert string to double without the numbers changing

AlteryxUser001
6 - Meteoroid

Hi All in order to enter formula i need to convert string fields to numeric which I can complete using the select tool. 

 

however the digits in the field then suddenly lose 3 digits after the comma and become completely different numbers.

 

is there a way to solve this

5 REPLIES 5
gautiergodard
13 - Pulsar

@AlteryxUser001 Could you please provide some sample inputs you are working with and sample desired outputs? 

FreeRangeDingo
ACE Emeritus
ACE Emeritus

If you remove the punctuation it won't remove the 3 digits after the comma.  You can remove punctuation with a Data Cleansing tool.  With punctuation, it will only be a string, not a number.  You can convert it back to a string and add commas at the end of your workflow after you are done working with numbers if needed.

binuacs
21 - Polaris

@AlteryxUser001 One way of doing this

binuacs_0-1669672758877.png

 

AlteryxUser001
6 - Meteoroid

thanks, is there any way of doing that without the need to create  a new column - as in, can that formula be applied to the amount column in your example below

binuacs
21 - Polaris

@AlteryxUser001 you can use the Multi-Field formula tool for that

 

binuacs_0-1669825020670.png

 

Labels
Top Solution Authors