Append Data from Two Different Excel Sheets

Hi guys,
I have two excel outputs from the same workflow, which have the same column structure but I want to append them in one file. Is there any way to do this? (I checked the append and overwrite options in excel writer but I encountered the following issues:

a) Either one file would completely overwrite the other
b) It would fail to add/append the data in the same file

Any input would be greatly appreciated!

If want a single table, then use the the Concatenate node before using the writer node.

If you want a single Excel file with 2 different sheets, then use the Excel Writer node with multiple sheet input ports (assuming you’re using KNIME 4.3). In previous versions you’d use the Excel Sheet Appender node


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