How to write ONE Excel file in a loop with multiple sheets originating from 2 columns

KNIME Analytics Platform
1

Dear KNIME Forum,
I have the following problem:

  • I would like to write the data from the overall table into 1 Excel file.
  • However, the data should be grouped into individual sheets, depending on 2 columns: Year and Technology.
    The sheet name should also be formed from these two columns, e.g. 2023_Laser, 2023_Bend, 2024_Laser, 2024_Bend …
  • I have already built a workflow. But unfortunately I can’t get any further. It only writes the data for 1 year (2023) and not the data for both years (2023 AND 2024).
    It would be great if someone had an idea for the solution. Thank you very much for your help in advance!
1 Like
2

Hi @Petra16091977

Have you enabled multiple input ports of Excel Writer node?

afbeelding

gr. Hans

1 Like
3

Great question! The way I would do it is use a group loop node on the two columns. Feed it into an excel writer node that writes sheets. And use a String Manipulation (Variable) node to feed the sheet name from the column values.

I’m not familiar with @HansS sheet input ports method, but it’s probably a more modern implementation.