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

[singh28ashish]

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..!!

[dkungu]

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

[singh28ashish]

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

[singh28ashish]

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

Input:

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

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