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.
Hi Sapna, Thanks, the formula working, the issue is data source side. Thanks
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!