Troubleshooting: ERROR: "Input Data (1) CSVFile: A field was missing a closing quote in record" when reading CSV files and using the AMP engine

[ntobon]

Issue

Error reading CSV files using AMP Engine

 

Environment

• Alteryx Designer
• Version 2020.2

Diagnosis

No error if  you don't use the AMP Engine. It doesn't happen with all CSV files. 

 

Cause

Error is displayed when reading CSV files with carriage return in it. The carriage return is in a string that represents a field surrounded by quotes.

 

Solution

There are new options in the Input Tool when using the AMP Engine. The Input tool needs to allow newlines in quoted fields:



Scanning for newline characters within fields within a buffer of text requires single-threaded reading. By default, we consider any line break to be a new record so we can perform multi-threaded reading. Checking the config option in the screenshot resolves the issue. AMP will perform a single-threaded read.
 

Additional Resources

https://help.alteryx.com/current/designer/alteryx-amp-engine

https://help.alteryx.com/current/designer/tool-use-amp

[Xi_Wang]

hi, this solution seems do not work to my issue, I still have the error. i also have tried un-pick the AMP engine, but same error still there. can someone help to solve it?

[mikepoirier]

I'm also still receiving the error after trying this solution. Please advise.

[maryamkoliaie]

I'm also still receiving the error after trying this solution. Please advise.