Hi, I’m trying to read one Excel sheet with multiple tabs. Each tab should be one variable and each variable should be output in one workflow branch.
For example: I want to analyse tab 1 and tab 2 in different branches. All the branches come together in the end and are being written into one excel file again.
I created the following workflow:
The idea is:
The reader node reads each tab in a loop, uses dictionary to name each variable (sheet order may vary and needs regex filtering). Eveything ist given to the case switch start as an input variable. Until here, it works fine.
The problem is: as far as I understand, the Case Switch functions as First match, meaning just one output is being activated at a time. However, I need all the outputs active all the time. I guess I’m probably using the wrong node then.
Do you have any suggestions to replace the Case Switch Start?