Hello everyone,
I have a workflow that ends with two Excel writers creating two sheets for the same file. I’m looking to add an extra sheet to this file with a comparison of both of these.
E.g. Sheet 3 shows columns A:C (which are the same for both sheets), then column D:G pasted values from sheet 1, and columns H:K pasted values from sheet 2
Thank you in advance
hi
for comparing the tables you could check out table difference finder node
br
Hello @trb22,
and welcome to KNIME Community!
If I got you right you can simply prepare data for third sheet in KNIME and write this sheet into Excel. You can also do it using Excel’s formulas but as long as there’s not a lot of data to be written I would stay with KNIME.
Also you don’t have to use multiple Excel Writer nodes to write to same Excel. One is enough as you can click on 3 dots located right bottom inside node’s icon and add additional sheet. See here workflow example:
Br,
Ivan
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.