Remove Scientific Notation from Long Numbers
- 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
Dear all,
I'm inputting data from an Oracle database and several of the fields contains a long number (always 17 digits). Alteryx is applying scientific notation to them which I can't find a way to convert from to create regular numbers.
I've tried the select and multi-field formula tools to no avail.
The closet I've gotten is the first 15 digits and then it just shows the last two digits as 00. I believe this is something to do with floating points but don't know how to remedy it.
Any ideas as to what I may try?
Thank you,
DHB.
- Labels:
- Help
- Input
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @DHB, this usually happens when the fields are brought in as string values. Does wrapping the fields in ToNumber() remedy this?
ToNumber([<Insert field>])
Failing that, converting the fields to a fixed decimal type may help, will just need to play around with the level of detail.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DHB, you just need a Select tool to change the data type of those fields to Double.
