Data from excel with Scientific Notation

[jperles]

I have several Excel files with different columns as input. One of these columns has both numeric and alphanumeric values of different dimensions. As you can see in the image, for numeric values of more than 15 characters, Alteryx automatically converts them to scientific notation.

Is there a way to solve this problem without having to open all the Excel files one by one?

[dataguyW]

If it were a small amount of Excel files, I'd recommend opening the file and setting the column datatypes.   Alteryx will read in the data depending on what is being passed in.  Once read in you can created a formula or select tool to convert to whatever you want if they were not consistent, but there can be errors along the way or some data could be lost.

[Qiu]

@jperles 
It seems that we can display Numeric Values to Full Extent by setting the data type to "FixedDecimal".
I did not this either, so thank you. 😁

https://knowledge.alteryx.com/index/s/article/Converting-Values-from-Scientific-E-Notation-158346017....

[jperles]

I have tried what you mentioned and when converting to fixed decimals the values are [null]. I don't know if it's due to the version of Alteryx I have.

[apathetichell]

ok - a bit of incredulity here - 1) I think what you see as your numbers in excel is hiding additional formatting options in excel. My hunch is based on Alteryx standard behavior which is not to convert numbers in string fields to anything. maybe it's misbehaving - but it might be on excel ends. 2) any strings in your field will be turned into null if you force convert to fixed decimal or anything. You need to figure out if you have a string field or a number field and handle accordingly. 3) you may to create a dummy field where you transfer out the strings, and convert the numbers - you can use regex or a filter or something to test this out.

[MadYX]

1. I used a filter to send any item with a "E+" or a "e+" in one direction.
2. In that lane i used a regex to find the digits (\d?.\d+)
3. in a formula tool you take out the decimal and append two zeroes to the end. Replace([REGEX],".","")+"00"