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