Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Knowledge Base

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




Error reading CSV files using AMP Engine

idea Skyscrapers




  • Alteryx Designer
  • Version 2020.2



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




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.



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