community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Bug: Reading numbers from Excel can produce floats

When Alteryx 2018.4.3.54046 reads an xlsx, it can "introduce" a float where there was none before. This only happens in a specific situation and it's not clear WHY it is doing this. The actual numbers are exact to 2 and 3 decimal places in Excel. It isn't a matter of formatting or display. That's what they are. An example number: 1.43.

 

If there is a string value in the same column, then Alteryx will read the entire column as a string. So far, so good. When it does this, some of the numbers now look like floats. 1.43 now looks like 1.42999999998 in Alteryx. Not all of the numbers get this weird float treatment.

 

I cannot control the source files and they may have strings in various cells of the "numeric" fields. I have to read everything as strings. I want to know why this happens and what to do about it. Thank you.

1 Comment
ACE Emeritus
ACE Emeritus

I had this situation early on and it drove me nuts. Nothing I did could change it, until I had a video chat with support.

 

In my case, there were NULLs in my number fields of which I was not aware. Once I added a NULL to zero formula, I had no more problems. Not sure if it will help you or not. 

 

if isnull([field]) then 0 else [field] endif