Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Outputting data to csv format

RichardAlt
8 - Asteroid

Hi guys,

 

I'm trying to output my data to CSV format. 

This is my data before I output it to CSV.

RichardAlt_0-1606722076776.png

and this is the CSV output.

RichardAlt_1-1606722149940.png

It converts the notation and the other rows 0 is gone.

 

But when I output this on .xlsx format it working.

Any ideas why?

 

Thanks!

 

 

 

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @RichardAlt 

 

The issue is not caused by .csv its actually caused excel.

 

.csv is a text file and all the column is saved as text. But when you open in excel it runs auto detect datatype to format according to the best suited datatype.

 

If you open .csv in notepad you can see that the data is still in proper format.

atcodedog05_0-1606722841570.png

when opened in excel

atcodedog05_1-1606722890786.png

 

PS: this just a display issue. The data is not lost in .csv

atcodedog05
22 - Nova
22 - Nova

Hi @RichardAlt 

 

The workaround for this would be to add a quote at the beginning or end like below

atcodedog05_0-1606723132892.png

Data in excel:

atcodedog05_1-1606723162950.png

 

This is a hack to make data look proper.

 

Hope this helps 🙂 Feel to ask if you have any questions

 

RichardAlt
8 - Asteroid

It is working now. What I did is something like this.

RichardAlt_0-1606723615311.png

Thanks!

atcodedog05
22 - Nova
22 - Nova

Glad it worked😀 @RichardAlt 

 

If my post was helpful. Can you mark the post as solution🙂

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @RichardAlt 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

mahesh_2355822
5 - Atom

Hi,

 

Could you please help us on how to save output into csv format?

Labels