Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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

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

grazitti_sapna
17 - Castor

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!

Sapna Gupta
Labels
Top Solution Authors