Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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