How to combine 5 Excel Writer output to 1 file

[Pragadeshgp]

Please need help to combine 5 Excel Writer output to 1 file

[bruno29a]

Hi @Pragadeshgp , I have to make some assumption here as we can’t really see what you are trying to achieve.

If you are trying to write to the same sheet, you can concatenate your data with:

Concatenate

and then write to Excel as one result.

However, if you are trying to write to the same file but in different sheets, then you can use the Excel Sheet appender instead of the Excel Writer if you are on older version of Knime, and configure a different sheet for each of these writes.

New version of Knime apparently can do the append via the Excel Writer (I don’t have a new version of Knime). This is discussed in this topic:

Replacement of Excel Sheet Appender

I’m using KNIME version 4.3 and found that the Excel Sheet Appender node is gone. Is there a replacement node for Excel Sheet Appender? Or should I use the new Excel Writer to append sheets and set the sheet name as flow variable? Appreciate any help on this. Thanks! Xenia

[Pragadeshgp]

Hi Bruno,

Thanks for the response.

I am getting five different output through the workflow. I have to combine these to one sheet like

below

Else i have to do it manually.

[Pragadeshgp]

Hi Bruno

I am good now, we use append option to make it as one sheet.

Thanks a lot @bruno29a

[AnotherFraudUser]

Hi @Pragadeshgp,

you also can add more sheet ports in the Excel Writer Node (the … in the lower left corner of the node).
Then you could add all sheets with one node