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
So while trying to create the test data, I realized that before I converted the data type to float I cleansed the data from letters. And since the decimal was written in scientific notation it had letters in it, so the cleansing must have gotten written of the letters turning my decimal into a whole number.
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.