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.
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.
@kamal03 use batch macro for your use-case also to write output into the same input file use the block until done tool