Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Apple_Orange
7 - Meteor

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

Sophia_Xiao_1-1652449377065.png

Alteryx showing as below:

Sophia_Xiao_2-1652449672104.png

 

11 REPLIES 11
DataNath
17 - Castor
17 - Castor

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

grazitti_sapna
17 - Castor

@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

grazitti_sapna_0-1652450672624.png

 

Another method would be manually changing the field to number type in excel.

 

I hope this helps!

 

Thanks!

 

Sapna Gupta
DataNath
17 - Castor
17 - Castor

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

Apple_Orange
7 - Meteor

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

 

 

 

Apple_Orange
7 - Meteor

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

grazitti_sapna
17 - Castor

@Apple_Orange , this is what I see when I convert it into a float or double.

 

grazitti_sapna_0-1652451266945.png

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.

 

Sapna Gupta
Apple_Orange
7 - Meteor

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
11 - Bolide

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. 

 

rfoster7_0-1652452631508.png

 

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

 

rfoster7_1-1652452696233.png

 

 

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
7 - Meteor

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.

Labels
Top Solution Authors