csv file show the full number from format 2.2912E+14
- 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
Hello All, Seek Help here. I have system auto generated csv file in this way. How can I get Alteryx to show the full number which doesn't have any decimals
for example, the first one 2.2912E+14, I would like it show as 229120000001152
Alteryx showing as below:
Solved! Go to Solution.
- Labels:
- Settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As it’s a CSV, Alteryx will bring this in as a string. Try wrapping the field in the ToNumber() conversion.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Apple_Orange , tonumber() would work or you can try to change the data type to float using the select tool.
I used this value 2.29E+14
Another method would be manually changing the field to number type in excel.
I hope this helps!
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So just put a formula tool on and use ToNumber([Number])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ToNumber doesn't work. To number show data as 227000000000000 which is not the orgnial data it is
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is csv data here which I want Alteryx to show the full number. Thanks so much for you swift reply
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Apple_Orange , this is what I see when I convert it into a float or double.
If this does not work then I believe you have to convert the column into a number in excel itself in order to use it in alteryx.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Sapna, from my first posting screenshot, it has the original csv file data look like which I upload to Alteryx. you could see the data is not end with 000000000. When I tried to save a copy of the csv file only show number column to share here, For some reason some data has been replaced as 0. Not sure why is that. but my original csv show the correct number.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
when I open your csv file in notepadd ++ it shows the values as n.nnE+14, meaning that you have a string field that doesn't have the full numeric value you are expecting.
when I open it in excel and look at it, I also see the same thing. YOu ahve lost your precision somewhere along the way before it gets to alteryx
Perhaps when copying and pasting into the example csv you gave us. Can you give us the original csv with the precision. I'm pretty sure either proffered solution will work with the data if the data has the precision.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Sapna, I notice the issue is when I use Alteryx to combine few csv file, number 229120000001152 will be shown as 229120000000000 in combine data.
