Append Data from Two Different Excel Sheets

KNIME Analytics Platform
1

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!

2

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

8 Likes
3

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