Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Input Data (10): CSVFile: A field was missing a closing quote

wonka1234
10 - Fireball

Hi,

 

I am getting error:

 

Input Data (10): CSVFile: A field was missing a closing quote in record 191: "[Legal entity name
Input Data (10): Too many fields in record #193

 

wonka1234_0-1685736368037.png

 

anyway I can bypass this error? This is an analytic app.

2 REPLIES 2
jdminton
12 - Quasar

I've run into this issue before. Typically checking the boxes in row 13 and 14 will fix it. Sometimes I need to make the text qualifier "None"  instead of "Quotes" to get it reading correctly. It's also possible you have a delimiter included as part of a field value. In those cases, I use a text editor to fix if there aren't many.

jdminton_0-1685739038451.png

 

acarter881
12 - Quasar

Hello, @wonka1234.

 

I believe I have faced this exact same error.

 

My solution inside the Input Data tool was as follows:

  1. Updated Field Length to 5000 instead of the default 254
  2. Code Page from ISO 8859-1 Latin I to UTF-8
  3. Check box for AMP Only: Allow Newlines in Quoted Fields
  4. Check box for AMP Only: Force Single-threaded Reading
 
Labels