How to convert from Scientific Notation (E) to Numeric Value

[mzp]

I am trying to figure out how to change from scientific notation (E) to numeric value. I tried using the select tool and change it to fixed decimals. Also tried using the formula ToNumbers (RegExOut11) and is not working. Does anyone have an idea how can I change it? The file input is in CSV and its not very clean, I had to use regex to parse values. 

thanks!

[DavidP · Accepted solution]

Hi @mzp 

Since the number is 17 digits long, you need to pick a datatype with an appropriate size. The options you have are:

Int64

Fixed Decimal 17.0

Fixed Decimal 18.0

Fixed Decimal 19.1

Fixed Decimal 20.2

etc.

Anything else and you'll get the error "Number does not fit in..."

[mzp]

Hi @davidP 

I thought that solved my issue but actually didn't. 

when I use Int64, it is just adding 0000.

For example before I upload the file the actual number for the first row is 012813004450753515 and not 1281300000000. 

could it be related to the file input format change?

[Jes]

Not sure if you were able to sort this out. Data Type of INT64 (integer)  will remove any decimals. Play around with the different data types by using a Select Tool to try out different data types.

Here is a link to the different data types available in Alteryx:
https://help.alteryx.com/current/designer/data-types