Too Many Fields in Record 2 with .csv as input data

I have a .csv file that is getting the "Too Many Fields in Record 2" error and won't advance past the input tool. This particular file comes to me with the first row completely empty and the data starts on row 2. My work-around is to open the file and delete the first row and this allows it to run my workflow fine and get the expected data.

I don't want to open or touch the file, just bring it in the workflow, but I can't find any other solution to get past this error.

I've read some of the other posts on this topic and tried:

starting data import on line 2

Changing delimiters to \0

adding to the field length

treating errors as warnings to at least read it and troubleshoot

Still no luck getting to my data. Does anyone have any experience with this? The work around is so easy yet i can't convert that manual intervention to an Alteryx process that does the same thing and resolves the problem.

Error Message

Accepted answers

danilang

Here you go

For future reference, the .yxmd file is just an xml file. Open it with notepad and change the second line to match your version

Dan

CSVImport.yxmd

All comments

danilang

hi @Rob48

The standard way to deal with this is read the file as CSV with line feed delimiter \n and then parse it in the workflow itself. If you can provide a sample I'm sure someone will come up with an answer fairly quickly

Dan

Rob50

ok here are the files for someone to work their magic. I've tried many of the suggestions here and nothing has worked.

"CSV file top row blank" is the untouched version that I'm having the problems with ("too many fields in record #1")

"CSV file top row deleted" works fine with the workflow i've been using which uses a cleanse, sample tool to eliminate the first few rows, and then a dynamic rename to take the field names from the first row of data.

i should also note during testing:

1. i open and closed the top row blank file; no change, same error message

2. i renamed the top row blank file; no change, same error message

3. i went into the top row blank file and changed some of the data (to make the data more anonymous) and I DIDN'T get the error message, it worked fine. ???

screenshot below of the configuration parameters that are not working.

CSV file top row blank.csv

CSV file top row deleted.csv

jcardoso

Hello,

i have the same issue, the result is an error "Too many fields in record 2", although with a diferent file, attached. Delimiter is semi-colon.
I need that first record and the 2nd one as header, so all the data in the file should be given in the output, so i can work out from there.

I have tried all the suggestions above and workflow but still the issue persists,

Thank you very much

data_file.csv

result.PNG

settings.PNG

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167