Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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