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