Error : When Quote Mode is Never, field cannot contain a delimiter character (record #3)

Question

Hi Alteryx Experts,

Facing issue while generating csv output file through Alteryx and column decimeter is comma(,). I have a special requirement to get all data in double quotes except integer. Workflow is failing because between data is having ,(comma) in one of col value as mentioned below.

Contract fixed rate USD1.00 vs IDR11,736.43

Attaching output filed screenshot as well wf.

Thanks in Advance..!!

Alteryx1_Data.PNG

Alteryx_Outputconfig.PNG

Copy of RT_AUTO_Final.yxzp

singh28ashish · Answer

we want csv file delimiter should be comma(,) and in one of the col. string has comma as well. below is example

Input:

REFERENCE_CODEABBREVIATIONCODE_LABELVALIDDESCRIPTIONCHILD_REFERENCE_TYPECHILD_ATTRIBUTE_TYPE1Fixed rate AUD 1.00 = USD 0.89271FIXED_RATE_AUD_1_00___USD_0_8927Y   2Fixed rate USD 1.00 = SGD 1.2722FIXED_RATE_USD_1_00___SGD_1_272Y   3Contract fixed rate USD1.00 vs IDR11,736.433CONTRACT_FIXED_RATE_USD1_00_VS_IDR1Y

Output :

"REFERENCE_CODE","ABBREVIATION","CODE_LABEL","VALID","DESCRIPTION","CHILD_REFERENCE_TYPE","CHILD_ATTRIBUTE_TYPE"
1,"Fixed rate AUD 1.00 = USD 0.8927","1FIXED_RATE_AUD_1_00___USD_0_8927","Y","","",""
2,"Fixed rate USD 1.00 = SGD 1.272","2FIXED_RATE_USD_1_00___SGD_1_272","Y","","",""
3,"Contract fixed rate USD1.00 vs IDR11,736.43","3CONTRACT_FIXED_RATE_USD1_00_VS_IDR1","Y","","",""

Please help on above. Attaching IP data for refrence

TIA

Alteryx_Issue.xlsx

singh28ashish · Answer

Hi @dkungu  Thanks for your reply. but it didn't worked out. Output should look like below attached.

Alteryx_Data.PNG

dkungu · Answer

change the highlighted configuration to 'Always' or 'Auto'.