Running workflow multiple times for all outputs to come through one excel file

I have a large workflow that has multiple outputs, but all the outputs are coming together into one final output. I am having to run the workflow 3 times in order for my final Excel file to have all the outputs I had created. I am hoping someone might have had this same issue, and figured out how to only have to run the workflow once and have all the outputs come through.

Output

Accepted answers

NickSm

@Gilbro4422

My thought here is that because you have many output tools writing to the same excel file, they're competing to write at the same time and that's causing errors generating some sheets until it's run enough times that they're all created.

Whats typically done here is to use the block until done tool - you'll probably want one or a series of them at the beginning of your workflow to branch out from, but with a Block tool in place your workflow will run, create the first sheet, run the next process and create this sheet, and so on.

Check out this article for reference:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separately-without-errors/ta-p/33413

All comments

NickSm

Hey @Gilbro4422 ,

Would you be able to share a little more on why you're needing to run the workflow three times? Are you making some changes with each run to create new results to append, or using new inputs?

A screenshot of the workflow may help for a little context as well.

Gilbro4422

No I am not changing anything between the runs. In my workflow I have several workflows that are doing different thing and all have their own outputs. I am saving those outputs into the same Excel file so I can create one Excel workbook that is has all my outputs. All the workflows are joined together at the end so that I could create an output that summarized all the workflows that are joined together at the end. It seems that maybe because there so much information coming that running each time pulls in another piece that didn't come in on the first or second run. It appears that running the workflow 3 times pulls in all the information that I created. I have attached my workflow and the excel file that hold all the information and how I want it setup. I just need to figure out how to only have to run the workflow one time and the Excel file contains all workflows being pulled in.

Adamg2.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703