How to convert from Scientific Notation (E) to Numeric Value
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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..."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
