Delete Row ID and Set new Row ID

KNIME Analytics Platform
1

Hello,

how can I delete the first row of an excel??
It is my ROW ID. I like to delete this ROW ID and Set the Row0 as my ROW ID.

Afterwards I like to merge the attached two excels (Audi year 2011-2012, Audi year 2013-2021) file into one excel file with the same columns used.

Thank you very much for your help.

BR
Bastian
Audi_2011_2012.xlsx (919.9 KB)
Audi_2013_2021.xlsx (920.5 KB)

2

Assuming you’re using the latest version of KNIME, in the configuration of the Excel Reader node you can input multiple files, and it will concatenate them based on the existing columns. You can also specify a range of rows and columns to read, and which row contain column headings.

It is my ROW ID. I like to delete this ROW ID and Set the Row0 as my ROW ID.

This doesn’t make sense to me. How can a row be a row ID?

1 Like
3

Great, It worked!

Thank you so much!

1 Like
4

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