CSV Reader

[andre]

Hallo
With the CSV reader, I imported a file.
The following error appears in the log:
Didn’t get any value for column(s) with index #1, #7, #17, #18,…
The data will be displayed correctly in the preview, but the Column Merger node will work as a result.

I’m looking forward to help
André

[mlauber71]

Could you provide us with an example. And also my twi recommendations would be:

1. try to use the File Reader instead of CSV reader (File Reader — NodePit)
2. if this does not work consider using the R package Readr if is much mor robust with CSV files
3. do not transfer data via CSV - ok just kidding but only to a certain extend …

Error with File Reader node while running in a loop

I had a similar problem where there were some ‘dirty’ CSV files out of a large number of files and they were too large to just ‘edit’ them in Notepad++ (and that also was not a very nice process). I built a workflow using the R package readr, which seems to me more tolerant towards problematic CSV files and gives you some control how to handle mismatching quotes and so on. You might have to toy around with the settings of the read_delim function. [46] kn_example_import_csv_r_readr.knwf (52.…

[andre]

Thank you for the info,
with the csv did not work, we have the csv converted to an xls.

André