We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to output a CSV with data delimited with anything but comma?

Amadeu_gustavo
7 - Meteor

Hello there,

 

I'm having troubles to parse a output data in excel, because my native language uses comma for cents (not a dot, like in English).

As my clients try to parse the CSV in excel only, it don't recognize as cents, but in dozens.

I'm trying to output a CSV delimited with tabs or "\", is this possible?

Then for parse the database my clients could use this parse:

 

Amadeu_gustavo_0-1600090313019.png

 

 

thanks since now

2 REPLIES 2
vizAlter
12 - Quasar

Hi @Amadeu_gustavo — Whenever you export data in CSV through the Output tool, the option auto appears like below:

 

vizAlter_0-1600090741483.png

 

You can use Tab as delimiter too:

vizAlter_0-1600090936682.png

 

echuong1
Alteryx Alumni (Retired)

You are able to specify the delimiter you would like to use in the Output tool. It defaults to a comma when you select csv as your output file type, but you can change it. 

 

echuong1_0-1600095332949.png

 

Labels
Top Solution Authors