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

[Apple_Orange]

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:

[DataNath]

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

[grazitti_sapna · Accepted solution]

@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 · Accepted solution]

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

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