I process Excels and produce dynamic the content of files within a loop. To avoid multple writes to the same Excel, I use the new feature with the additional tab input connectors. This works fine, but I realized, that I cannot disable writing one of those tabs. As a consequence I have to:
resort my tables (move all inactive ones to the end)
resort the tab name list accordingly
select in a dedicated writer node the correctly prepared Excel writer with the correct number of input tabs and write out the Excel
I found out, profiding this logic is no peace of a cake. Having the possibility to have only one node with your maximal number of input tabs but an option (at least accessible by flow variables) to enable/disable a tab to be written would be very helpful when processing Excels within a loop.
Sorry, but may was to unspecified, but I implemented a logic based on a case. But this logic is not scalable and unflexible. Having this implemented as a switch in the node would extremly help to reduce complexity in my workflow. I must no longer resort the tabs dynamically and provide an excel writer for each possible number of (acitve) tabs. I invested days until this logic worked, the number of used nodes (and by this the save-time) just exploded (despite of using shared components). As I would love to deimplement this logic and replace it with node logic, more important is, that other Knimers may have similar needs and can avoid the big effort to implement add. logic.