Issues with float variable in Alteryx incorrectly transforming my numbers

Tiffany01

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!

Bennel_Wilson

So,

If this is what is causing all trouble and all you need to remove are letters, then in the data cleanse tool uncheck the "Punctuation" option, this will leave all punctuation marks like "." in place and not remove them so your decimal point will remain.

Let me know if this works.