Input tool error with new line and commas

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.

New lines and commas with input tool.yxzp

AMP Engine

AMP-Engine

Accepted answers

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

All comments

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:

Alteryx version information
Screenshot and description of the issue with full error message
Replication steps
Frequency and severity of the issue
Troubleshooting steps taken so far

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

Quick Links

Tags

This months top contributors

AkimasaKajitani 388

Hollingsworth 335