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. 

Tonya_Smith

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-Analytic/ba-p/727785

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-Engine/ba-p/574809

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-threaded-processing-AMP/m-p/603329#M134951

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

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

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