Appending columns to existing excel file

[jinbaba]

I have a master table [excel file saved on my computer- let’s call this file 1]:

Column A , Column B, Column C

To this i want to add information from another file - file 2… which has the same column headers

how do i go about it? any ideas.

[ipazin]

Hi there @jinbaba,

so you would like to concatenate data from 2 Excel files? In that case you need to read both files in KNIME, use Concatenate node and write data back to Excel file.

Otherwise if you would only like to read one file and update another Python would probably be a way to go. See this topic: (there are also similar ones so it is worth searching forum)

Append data from 3 DB query reader to 3 different tabs in XLSX

Hello team, I am reading data using 3 queries in 3 different Query reader. I have one excel file with raw data as output. Everyday, this file has to be updated with new data from prior day. I have output from 3 DB Query Reader. I used “Excel Shee Appender” but it wipes out existing tab and creates new one (basically replaces a tab), instead of “Append” to the last row… I saw several posts that says, there is no “APPEND” feature with existing data. I have to write to 3 different tabs. New to…

Br,
Ivan