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
12 - Quasar

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
12 - Quasar

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