Exporting Data into Csv file with double quotes

Question

Hello Everyone,

I have a dataset which needs to exported to a csv file which will have double quotes. Is there any option in the output tool that will enable me to do so?

Any lead will be appreciated..!!

Thanks in Advance for your help.

Thanks,

Bitopi

Emil_Kos · Answer

Hi @Bitopi,

You need to change it to string as you cannot add any extra signs to numbers. If you would be interested in adding $ to the number to make it a currency column like 1000$ you would need to change the data type to string first.

Bitopi · Answer

Hi Emil,

I have tried following the suggestion mentioned in the above link.. but I am getting an error message. It is showing ''Type mismatch in operator +" in the multi-field formula tool.

All the variables except one are in V_String. Only one variable is Double. Shall I change the datatype of the numeric variable to string? Please suggest.

Thanks,

Bitopi

Emil_Kos · Answer

Hi @Bitopi,

I think you can use multi-field formula to make it work:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/CSV-output-gt-double-quotes-for-certain-columns/td-p/141857