Unable to read file as .csv or .xlsx into KNIME

KNIME Analytics Platform
,
1

I have a file that I can’t get loaded into KNIME no matter whether I use the csv or excel file reader node.

The issue appears to be with the file itself as I can load in and execute other files in KNIME. If I deselect some columns for inclusion in the Dialogue box then the file can execute, however I need these columns included. I also unexpectedly get errors suggesting that random rows have values in additional columns, but this isn’t the case. I have copied only the columns that I want into excel and pasted as values, but still no luck.

2

Hey there and welcome to the forum.

I have seen behavior like this in the past and in most cases it turned out that there indeed was additional data - or unexpected data in a certain column - e.g. a numeric column that contained a random “dash” (typo during data entry) which, with wrong reader configuration, makes the node fail.

To provide more specific guidance can you share screenshots of the errors etc?

Typically the error should indicate which row is causing an issue etc., which gives a starting point to further debug.

2 Likes