Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

Issues with float variable in Alteryx incorrectly transforming my number

5 - Atom



I have a few numbers that incorrectly transform in Alteryx. I want to keep the original value that was written in Excel, but Ateryx looses my decimal places when I change the variable to the float data type. All of my other numbers transformed correctly, however they were not 3 decimal places and less than 1. 


# in excel          # initially in Alteryx         # after change to float data type

.003                        3.0000..01-3                                   3

.002                                 2-3                                         2



12 - Quasar

Hi, @Tiffany01 


Kindly consider using Fixed Decimal and see if that helps.

17 - Castor
17 - Castor

Hi Tiffany


It looks like the numbers that are not being converted are shown in scientific notation and possibly being treated as strings.  Can you provide a small sample of your input excel file?   You can remove all the columns except for the number column