Alteryx Engine vs AMP: Block until done error generating multiple tabs in same excel sheet

[someotherguy]

After upgrading a workflow to AMP, I received an error when generating two tabs in the same file shown below

The documentation says to place the BUD tool in the branch with the lowest numbered Input tool ID.  How do you determine that?

I couldn't figure out which one had the lowest tool ID so tested with deleting either BUD tool and it runs with no issues.  on further research of the topic I discovered how to properly nest multiple BUD tools

 https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Block-Until-Done/td-p/895920 

 I have since adjusted each tab to be created from the different branches of a single BUD tool, previously I put one BUD tool immediately before each output tool that generated a tab. 

[TonyaS · Accepted solution]

Hi @someotherguy ,

Thank you for this feedback. We have had other questions about Block Until Done and writing multiple sheets to the same file, so we are considering adding a future enhancement to our roadmap that will make this easier. 

To identify the Input Tool with the lowest ID,  you can either click on the Input tool and view it in the configuration pane or hover over the tool and it will show the tool ID. 

Also, thank you for reading the documentation on AMP differences and finding that. 

Here are some more AMP related links in case you are interested: 

AMP Engine webinar (32 minutes): https://community.alteryx.com/t5/Analytics/AMP-Engine-Discover-the-Untapped-Performance-of-Your-Anal...

https://help.alteryx.com/current/designer/alteryx-amp-engine

https://help.alteryx.com/current/designer/Alteryx-Engine-and-AMP-Main-Differences

https://help.alteryx.com/current/designer/AMP-Memory-Use

https://help.alteryx.com/current/designer/tool-use-amp

https://community.alteryx.com/t5/Analytics/Accelerate-Your-Analytic-Processes-with-the-New-AMP-Engin...

https://community.alteryx.com/t5/Engine-Works/AMPlify-your-Workflows/ba-p/617590

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Best-practice-with-the-new-Multi-threa...

AlterEverything Podcast: https://community.alteryx.com/t5/Alter-Everything-Podcast/66-The-Alteryx-AMP-Engine-Explained/ba-p/5...

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-1-Why-AMP/ba-p/570...  

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-2-Key-concepts-of-... 

[someotherguy]

I only have one input tool for the entire workflow so that's what caused my confusion.

[TonyaS · Accepted solution]

Ah, did you figure it out? The BUD needs to be associated to each thread going to the output: 

[someotherguy]

yes that solved my issue.  When I first started researching how to generate two tabs in the same file I think I ended up on this thread

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-multiple-files-to-different-exc... 

And implemented something like this, but didn't realize it was discussing multiple inputs