Help related to Block until done tool

[kamal03]

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.

[Bren_Spill2]

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.

[Raj]

find the sol attached.

[binu_acs]

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