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!
Solved! Go to Solution.
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
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
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
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
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
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
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
@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