CSV reader doesn't read all column names.

[Paul2020]

Hey all,

For some reason the headers won’t carry over from a csv reader node after it has been read. Anyone have any insight on this? Thank you.

Please find attached both the image of the read table (above) and the csv file itself (below)
Whakaari_csv_displ.zip (339.3 KB)

[elsamuel]

I’d recommend using the File Reader node instead of the CSV Reader node.

[HansS]

Just drag and drop the file into your KNIME canvas

[mlauber71]

@Paul2020 welcome to the forum. File reader does work indeed.

kn_forum_csv_import_whakaari_displ.knwf (1.7 MB)

[ipazin]

Hi there @Paul2020,

welcome to KNIME Community!

This happens cause you have # character in your column header name and by default that character is comment char.

If you replace it or just delete CSV Reader works as well. At least for for header, that is what I have checked

Br,
Ivan