I want my workflow to write several excel files (Excel Writer) and append some sheets (Excel Sheet Appender) in those. Therefore it is important for me to have the right order of execution.
How can I set that it will
Write an Excel
Append a sheet in the Excel from 1
Append another Sheet in Excel from 1
Write another Excel
Append a sheet in Excel from 4
If my previous nodes for 2 are faster then 1, then KNIME will append a sheet in a existing file from the last run. Somebody an idea?
to ensure a right order of execution one should use flow variable connections. Not sure about your workflow design but can see Wait… node alone not being sufficient in this case.
Hi @ipazin
Well, actually a example would be great as my waiting-node is running but not getting to an end, so the Sheet Appender is not getting started.
if your intention is to run right Excel appender from picture after the left one simply connect two of them with flow variable connection. Something like this:
It will ensure that Node 34 is executed after Node 32 is executed. If you have a more complex workflow design are you using loop for writing data into multiple Excel files? If this still doesn’t help can try explaining it a bit more?
But that’s it - thanks a lot!
