Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

CSV output > double quotes for certain columns

Fred
5 - Atom

When I select the "Output Data Tool", there are three options for "Quote Output Fields": Never, Auto, Always. I need to add double quotes to all columns except the columns containing amounts. Is there a way to get this done using the "Output Data Tool" or do I need to fix this prior the output tool using the "Formula" tool?

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
I would use a multi field formula.

'"' + [_currentfield_] + '"'

But beware! If your string length isn't big enough, you might truncate your data when the value approaches the field limit.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels