I've got a large csv file (2+ GB) that when I run it occasionally returns an error for CSVFile: A field was missing a closing quote and or An unescaped quote was found.
see csv and workflow settings a bit further down the post
the strange part is when this error happens the Alteryx error's on different lines everytime.
so 1st run:
Record #270 An unescaped quote was found.
Record #3: CSVFile: A field was missing a closing quote in record 3
Record #150234 An unescaped quote was found.
Record #52: CSVFile: A field was missing a closing quote in record 52
same thing different record number
This also happens with the closing quote
things to note about the csv file.
this file I'm getting the warnings on is static. it doesn't change from run to run
furthermore I'm using an inputtool and the settings are as follows: AMP disabled, (see screenshot) .
to add to this. if I open the csv file in notepad++ there are no quotes to be seen .
I would expect to see the following:
"Header1" "Header2" "Header3"
"Foo" "1" "XYZ"
"Bar" "2" "ABC"
but got this instead (NOTE: in post there are spaces but in the file these are tabs)
Header1 Header2 Header3
Foo 1 XYZ
Bar 2 ABC
Am I doing something wrong with processing this data or should I enable some settings?