Help related to Block until done tool

Question

Hi,

I need help related to the block until done tool.

I have one Excel containing 3 sheets (A, B, C). I need to perform some operations in those 3 sheets and then store them in one Excel containing all 3 sheets (A, B, C) with updated calculations.

I already build one workflow which is working fine but I need to know if there is any efficient method to solve this.

Like:-

Instead of using 3 block until tool we can use one ?

Is there any way to store the data in the input file only after running the workflow?

I welcome for any suggestion

Please find the below workflow.

test worklow.yxzp

binu_acs · Answer

@kamal03 use batch macro for your use-case also to write output into the same input file use the block until done tool

test worklow.yxzp

Raj · Answer

find the sol attached.

test worklow.yxzp

Bren_Spill2 · Answer

Hi @kamal03 - if the schema is the same for all three sheets you can union the data an use the Take File/Table Name From Field section in the output tool. See attached.

Workflow.yxzp