Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

someotherguy
8 - Asteroid

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

someotherguy_1-1652986118687.png

 

 

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

someotherguy_0-1652985874954.png

 

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

 

 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. 

someotherguy_2-1652986621780.png

 

  

 

4 REPLIES 4
TonyaS
Alteryx
Alteryx

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. 

 

TonyaS_0-1652988177727.png

 

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-... 

Tonya Smith
Sr. Product Manager, cloud App Builder
someotherguy
8 - Asteroid

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

TonyaS
Alteryx
Alteryx

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

TonyaS_0-1652989530579.png

 

Tonya Smith
Sr. Product Manager, cloud App Builder
someotherguy
8 - Asteroid

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

someotherguy_0-1652992681709.png

 

Labels