CSV output from Alteryx data type selection

Question

Hello there,

I'm trying to generate CSV file out of Alteryx which is connected to SQL server. The problem is with account number and it has 16 digits when I Alteryx spit out the CSV it has some scientific notation, and if I change it into FRACTION data type it works. But I don't want to change it manually and want data as is. I have tried different data type in Alteryx from String, integer but no luck.

Account number 123456789123456798123545678192874512398109273456

CSV output:

Account number 4.42868E+154.42868E+154.42868E+154.42868E+15

Can someone please advise what should I do?

Appreciate your help!

Thank you

Mehul

tk12 · Answer

Hi @ggruccio

Thanks for the quick response. Actually the input source is SQL, and output should be .CSV, when I try to open it in notepad it's working fine as you pointed out below. I want to automate this process, like hand over the Alteryx WF to end users and they can create CSV out of it based on the ASOFDATE.

In SELECT tool I have tried few different data type but it doesn't seem to work. I mean if there is something CSV can't handle we are out of option and have to manually update the datatype, so be it. But was curious if something that can be accomplished from Alteryx itself.

Thank you!

ggruccio · Answer

Hi @tk12

I've tried a very simple text input of your data and written to .csv  The underlying data appears to be writing correctly.  Here I've opened the csv below in Notepad and in Alteryx....

Seems to be an Excel setting where I open it and it displays in scientific notation.  Although if you look at the actual value in the window for the cell it is dropping the final digit and converting to zero.  Even changing the format in the field drops the final digit.... not sure how to correct...but maybe some setting in Excel - (assuming it is Excel you are trying to open it in?)...actually I see you are writing to SQL server...may be some setting there?