This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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