CSV files column header in the forth row

KNIME Analytics Platform
1

I have a bunch of CSV files and all of the files have the same format. However, the column name starts on the forth row. Which I want to remove the first three rows and convert into without consolidating all files into one file.

However, I cannot even should the folder I want in my “csv reader” step.
I am not sure what goes wrong here. Can anyone advice me how should I do it?
Thanks.

image
image1111×279 44.6 KB

1.csv (32 Bytes)
2.csv (32 Bytes)
3.csv (17 Bytes)

2

Hi,
your CSV Files are a bit tricky due to unusual letters. If I need to process csv files I often use this workflow:

3

Hi @newba, Your problem solved?

image
image1402×856 99.3 KB

One question, 3.csv is your input file as well?

4

Have you tried the Row to Column Names node?

1 Like