06-25-2020 02:58 PM - edited 07-23-2021 05:02 PM
Issue
Error reading CSV files using AMP Engine
Environment
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.
https://help.alteryx.com/current/designer/alteryx-amp-engine
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?
I'm also still receiving the error after trying this solution. Please advise.
I'm also still receiving the error after trying this solution. Please advise.