I am having some issues with the CSV reader trying to read a CSV output from an ERP system.
I get the warning “Didn’t get any values for columns with indexes #46, 47, 49, 51, 52, 53. Please verify column types.” This warning confuses me because I only have 20 columns in the data.
Then it fails to execute with the error: too few data elements (line: 2 (1637)
When I enable short lines I get the same warning, but it does execute. Though for some reason it gets rid of my column headings and puts in a ton of blank columns at the end.
Is there anything I can do about this? I am trying to build a tool that I can leave with a client and having to rename 19 columns and drop 30 or so others seems like an opportunity for errors down the line.
Thanks in advance,