Import: "too many data elements"

KNIME Analytics Platform
1

Hi,

I have been attempting to import data from a csv file using the CSV Reader node and the File Reader node. The file has more than 1.000.000 entries and the error message says that in row 1.104.807 there are “too many data elements”. Unfortunately, I cannot trim the file in Excel and I am not being shown the row in which the error occurred since only the first 1.000 rows are being shown in the preview.

During the third attempt the File Reader (Complex Format) has been used and now the error message “too few data elements” is prompted.

Best regards!

2

@MDA welcome to the KNIME forum

This sounds like there is an additional column separator that makes the line inconsistent. You can try to use “support short data rows” - but this might compromise your line with the problem. Or you can fix the data source (or not use CSV in the first place).

image

Another alternative might be R/readr package:

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.