Data from excel with Scientific Notation

Question

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?

MadYX · Answer

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

Scientific Notation Tools.png

apathetichell · Answer

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.

jperles · Answer

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.