csv file show the full number from format 2.2912E+14

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:

Settings

Accepted answers

grazitti_sapna

@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!

DataNath

So just put a formula tool on and use ToNumber([Number])

All comments

DataNath

As it’s a CSV, Alteryx will bring this in as a string. Try wrapping the field in the ToNumber() conversion.

grazitti_sapna

@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!

DataNath

So just put a formula tool on and use ToNumber([Number])

Apple_Orange

ToNumber doesn't work. To number show data as 227000000000000 which is not the orgnial data it is

Apple_Orange

Here is csv data here which I want Alteryx to show the full number. Thanks so much for you swift reply

Data.csv

grazitti_sapna

@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.

Apple_Orange

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.

rfoster7

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.

Apple_Orange

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.

Apple_Orange

Hi Sapna, Thanks, the formula working, the issue is data source side. Thanks

grazitti_sapna

It happened to me a while ago when I was trying to migrate data from CSV to a platform. Whenever I opened the CSV the number formatting automatically changed from decimals to INT. Suppose one of the numbers was 1.00 so it displayed the number as 1. In that case, what I tried was not opening the CSV file and directly importing it to CSV it worked for me. The other thing I tried was copying the CSV data into excel and then using the file after formatting it.

I hope this helps!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703