Alteryx Designer

Definitive answers from Designer experts.

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

Alteryx
Alteryx
Created

Issue

 

Error reading CSV files using AMP Engine

idea Skyscrapers

 

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:

idea Skyscrapers

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