Appending columns with different header names (excel)

Hi guys,
I am appending two different workflows in the same sheet in Excel , however I need the column headers of the appending file to appear underneath the file which is being appended (with concatenate we have only the union or intersect option and with excel write it overwrites completely). Does anyone know how to tackle this problem? It would really help

Hello @XNS140,

Excel Writer doesn’t have append data to existing sheet functionality so you will have to prepare complete data you want to have on single sheet in KNIME itself and then write it down. To do so in your case you can use Concatenate node but before that make headers of second table as first row values (use Extract Column Header and then Concatenate node). Additionally you can format your Excel files using Continental Nodes for KNIME extension.

Hope this helps!

Br,
Ivan

2 Likes