Alteryx Designer

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

Issues with float variable in Alteryx incorrectly transforming my number

Highlighted
5 - Atom

Hello,

 

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

 

Thanks!

Highlighted
12 - Quasar

Hi, @Tiffany01 

 

Kindly consider using Fixed Decimal and see if that helps.

Highlighted
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

 

Dan

Labels