Numeric Data Types

grsomer

Hi,

When I bring my Excel spreadsheet into Alteryx, Alteryx reads some of my numeric data fields as V_String data. When I use a select tool to manually change my fields to Double, I loose some of the precision of my number. Specifically, if my number was 530,000, when I change it to Double it becomes 530. Obviously, this means that my data is now incorrect. Is there a way to keep the precision of my number while changing it to a numeric data type? Should I be using a data type other than Double?

Any help is appreciated! Thank you!

Dynamomo

Looks to me like your numbers are coming in as strings with commas in them.  when you change a string to a number, the number is read in up until you get to a non-numeric character (the comma) so that's why it was truncated at that spot.

I'd use a formula tool to replace the comma with nothing ("") which would remove the comma, then convert the field.