hi @StefanusJPK
There are a few options. Without knowing the specifics, you can try:
1) The Block Until Done tool. https://help.alteryx.com/current/designer/block-until-done-tool which basically put the procedures on a "queue" where the procedures in the 2nd queue cannot start until the 1st queue is done and so on...
2) Use Batch Macro. I assume that 1) you are familiar with Batch macro already, 2) there is only 1 input file with multiple tabs that you want to extract data from, 3) for each different tabs, you want to repeat the same procedures, but output to different file/tab. In this case, you need only have 1 macro input in your batch macroy .yxmc file.
- Connect the file you want to process into the "input" anchor.
- Get the list of sheet names > connect to the "inverted question" anchor. The input to the inverted question should include at the minimum: (i) the list of sheet names that you want to read from, and (ii) the path of where you want to write your output too.
Hope this makes sense.
Dawn.
