Merging multiple rows into one single header row

Hello!

I am quite new to KNIME.
I am trying to concatenate multiple Excel files together, however, their header rows are in multiple rows like this:

image

Is there a way how to merge first 3 rows in a single header row without doing it manually in Excel?

Regards,
Nick

Hi @Analyst_Nick

Welcome to the KNIME forum. I created an example flow to fix your issue. Its not fully automated. In the row splitter you have to define the number of rows your header consist of.
Merging multiple rows into one single header row.knwf (15.7 KB)

Succes,

gr
Hans

3 Likes

A post was split to a new topic: Error adding nodes

Hi,

Although @HansS has provided the solution to merge the header rows, here I have a solution to merge headers and also assign them as the column headers:

column_headers.knwf (24.9 KB)

Best,
Armin

3 Likes

This is great, thank you!

1 Like

Hi, thank you for your input! Your version is a bit faster.

2 Likes

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