Overwrite several single cells using multiple output tools

[r0deo4pple]

Hi guys,

my problem is that I have an input sheet in excel and I just want to overwrite 3 single cells(E16, E25 & E29). For example, cell E16 with "111111", cell E25 with "Google" and cell E29 with "Germany". I tried to use an output tool for each individual cell and selected "overwriting sheet or range" with range E16 on the first output tool, E25 on the second and E29 on the third.

Unfortunately it did not work.

Is it correct to work with multiple output tools or can one output tool do it for several individual cells?

Do you have any suggestions?

Thank you very much for your help!

[ShankerV]

Hi @r0deo4pple 

Yes, It is possible. Making use of Block until done will help to overcome the issue.

Could you please screenshot of the output to have a look.

Many thanks

Shanker V

[r0deo4pple]

Hi @ShankerV

I used block until done tools, maybe they are located wrong. I put them right after the Input Tool.

This is the wanted Output.

Many thanks

r0deo4pple

[ShankerV · Accepted solution]

Hi @r0deo4pple 

Please find the expected result.

Input file:

Post running the output result:

workflow:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @r0deo4pple 

Step 4:

Step 5:

Step 6:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @r0deo4pple 

Step 7:

step 8:

Step 9:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @r0deo4pple 

Step 10:

Step 11:

Hope the sample workflow created to achieve the result helps you.

Please amend the workflow as per your business requirement to get the desired result.

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @r0deo4pple 

Step 1: Input

Step 2: 

Step 3: 

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[r0deo4pple]

@ShankerV many thanks, it worked!

My problem was that I didn't worked with block until done tools yet and I didn't know how to use them and where. My data comes from one input tool but was then prepared in three different streams. I used an union tool and tried your way and it perfectly worked out.

Thank you very much!

Kind regards

r0deo4pple

FYI. my workflow 

[ShankerV]

Hi @r0deo4pple 

Glad that my solution worked!!! 

Happy to help!!!

Many thanks

Shanker V