Writing to > 1 excel sheet

KNIME Analytics Platform
1

Hi,
I am trying to write to multiple sheets. I have two branches coming off the CSV reader (Among a few string manipulations). Then, I branch into 2 branches by using row filters. Each of those write to the same excel file, but different sheets. When I execute the workflow, only the 1st workflow actually writes anything. I feel like the second one is getting blocked due to the first one writing to the file.

What is the solution to this?

2

Hi @DataSci6497 .

Make precedency. Try connecting the output variable of the first excel writer, with the input variable of the second excel writer.

Br

3 Likes
3

Hi @DataSci6497

Or add a wait node like this
afbeelding

gr. Hans

3 Likes
4

That’s what I’d recommend - to visualize it:

image
image886×396 26.4 KB

4 Likes
5

Thanks! That will do it!

1 Like
6

Thanks, this will do it, and thank you for adding the flow!

7

Thanks! Why do you need to Wait node here? BTW…I’m glad to know there is a wait node. Wouldn’t the output variable connection solve the problem alone?

8

If you connect the Excel Readers as shown you should not need a wait node as far as I know as the start of the second writer node is now dependent on the first node finishing…

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.