Convert exponential values to Numeric

[Beena]

While reading data from Excel source many times in case of very large/very small numbers it get's converted into exponential format. Currently we do not have anything in Alteryx to handle exponential numbers and convert them into numbers. "Exponential Notation. Exponential notation lets you move the decimal point in a number. It simplifies numbers by getting rid of zeros, and making math easier. Getting rid of zeros helps with big 100,000,000 and small 0.000,000,001 numbers. The Scientific format displays a number in exponential notation, replacing part of the number with E+n, where E (which stands for Exponent) multiplies the preceding number by 10 to the nth power. For example, a 2-decimal Scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power."

[danielkresina]

In my experience this only happens when reading data form the old .xls format files. If you're using the new .xlsx format then Alteryx bypasses the old JET driver and reads directly from the XML contents of the file and brings in the actual numbers not the scientific notated version that the Excel driver defaults to.

[ak2018]

Nope. I have an xlsx file that it still does this to it. If I use Double data type, it will truncate stuff but if I do a FixedDecimal, it gives me warnings about the exponential values as not a numeric type. So annoying.