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]

Hi,

I'm unable to exactly simulate the outcome. Would be able to share a sample data and your workflow.

Regards

Benn 

[Tiffany01]

All of my data is correct except for a couple lines of data.

Essentially I noticed, if  I have a number in Excel that is less than 1, such as ".002" Alteryx converts it to "2."

[Bennel_Wilson]

Hi @Tiffany01 ,

That is never the case. If you could share some sample data in excel and the workflow you are using, either I or someone from this community should be able to troubleshoot the cause.

@RobertOdera Any idea  on this?

Regards

Benn

[Tiffany01]

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. 

[Bennel_Wilson · Accepted solution]

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.

[RobertOdera]

Sorry, @Bennel_Wilson 

Just seeing this now!

Yes, it always helps is we have a sample or detailed explanation.

A definite way to go if those Cleansing Tool parameters were activated.