Start Excel Sheet Appender Node after Excel Reader node node is finished.

[Frank2323]

Hello,
The first excel reader node is creating a Excel file with the settings overwrite if file is already existing.

The following eight excel reader nodes are referring to the same file with the settings append and overwrite.

I want to append the following eight excel sheets to the first excel file.

But the problem is, that the second or thrid excel reader is running first and then the first excel reader node is running. I’m getting a lot of different error messages.

Is it possible to generate a order of all excel reader nodes? Meaning, the node on the top should run first, then the second one, then the third one and so on.

Thank you.

[rfeigel]

Read this post.

Setting an order for KNIME nodes execution

Hello,   I am working on a workflow in KNIME where the process branches into 6 operations, I would like the operations to be done in a sequence, so when the first branch is done, the second branch would start and so on. Is this possible to do in KNIME 2.8.2? Thanks, Error404

[takbb]

The following post contains a simple picture of what is described in @rfeigel’s post

Nodes execution order

Hi @verknuepfer, 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: [AppenderOrder] 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? Br, Ivan

As a further note, are each of the flows appending different tabs on the Excel file?

If so, you could potentially use a single Excel Writer, and create multiple input ports (one for each tab)

Alternatively, if they aren’t writing to multiple tabs, you could do similar with a Concatenate node prior to the Excel Writer, and have that feed into the single Excel Writer node.