In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to fix the "A field was mssing a closing quote in record.." in the data?

bryanmac_92
8 - Asteroid

I am trying to solve this data input error where it says "CSVFile:A field was missing a closing quote in record".

Not exactly sure how to fix this? I have the "Treat Read Errors as Warnings" clicked in options but still give an error.

 
 

Capture.PNG

4 REPLIES 4
TimN
13 - Pulsar

If you just want to bring the data in then this may help.  I don't parse anything 

jdminton
13 - Pulsar

Select the "Allow Newlines in Quoted Fields" option in the configuration pane. Also, if you haven't already, increase the field length to allow for more characters as some exceed the 254 default.

 

Snag_4532c533.png

 

jdminton
13 - Pulsar

One additional option is to change the delimiter to \n or \0 and set to ignore delimiters in none

Snag_453709ca.png

Labels
Top Solution Authors