Two header rows in output table

[Kazimierz]

Hello KNIMErs,

My task is to:

1. Read excel files where column headers are in two top rows.
2. Compare data between both input files.
3. Generate single excel output file (with Excel Writer node) where column headers are in two top rows again.

Sample header rows in input files look like this:

Header rows for output file should look the same.

The challenge is with point #3: generate single excel output file where column headers are in two top rows again. I know how to transform two header rows into a single header row, but I don’t know how to keep two header rows in an output excel file and I haven’t found anything like this on the forum.
Any suggestions?

Thank you in advance,
Kaz

[aworker]

Hi @Kazimierz,

Maybe you could adapt the solution implemented in the following topic:

Double Quote the entire data except for column headers while writing into CSV File

Hi Everyone, Hope you all are doing well. I am stuck in one of my workflows and need your help. I have a processed dataset with 120 columns in KNIME. The requirement is I need to save the data in CSV file in a way that the complete data is within the double quotes except for the column headers. I tried using the Quote char option while writing the CSV file but it double quotes the column headers as well. I just need the values in all the columns to be in double quote and not the column head…

The trick would be to use in a 1st step an -Excel Writer- node to just write the headers and all the rows in a 2nd step using again an -Excel Writer- node to save all the rows but this time configured with the checking of the “append” radio button option, the unchecking of the “Write Column Headers” option and the checking of “Don’t write column headers if sheet exists”.

Hope this helps.

Best
Ael

[Kazimierz]

Hi @aworker
Thank you for your suggestion. I will play with appending rows and share my feedback here.
Best regards,
Kaz

[Kazimierz]

Hi @aworker

I can confirm your idea works for me with some extra tweaks. I’m getting excel file with two header rows as per my expectations:

In fact, while building-up header row-by-row, it is possible to create multi-row header, where ‘multi’ stands for >2.

Thank you and happy KNIMEing,
Kaz

[aworker]

Hi @Kazimierz

Thank you for confirming that it worked. I suggested the solution from my mobile phone so I had to guess it by heart out of the hat

Thanks a lot too for having validated the solution so that other KNIMErs can easily find it

All the best and happy KNIMEing too !
Ael