I have just happened upon an issue with input tools when run using the AMP Engine.
Essentially, if a CSV file has a multi-line record that is usually denoted by double quotes and there is a delimiter in one of those new lines, then the AMP engine fails to read the file correctly.
I have attached an example of what I am experiencing to help demonstrate the issue, @TonyaS
Any suggestions would be appreciated.
Solved! Go to Solution.
Can you please email support@alteryx.com with information about your issue? Someone from our support team can take a look at this with you.
It may be helpful to include the following information:
Hi @DavidLane,
You need to check the AMP Only option 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.
Jerad Rades
Engineering
@JeradR, that did the trick. I had not spotted that option as it was hidden at the bottom of a scroll menu.
Thanks for your help. David
Thank you @JeradR I was just about to start looking for that other thread where you mentioned this when it came up previously.