Default AMP engine block output to Excel multisheet

[Genevieve]

Version 2022.1

Using AMP engine when outputting to multiple Excel sheets is creating errors, even when using the Block until tool.  

Basically the AMP is trying to write to the same output at the same time.

A work around is to disable the AMP and run on the traditional engine. BUT the newest version of Alteryx Designer, 2022.1, is pushing for the AMP engine even at the time or pressing Run.

 The process cannot access the file because it is being used by another process (32).

Could the problem either be fixed or remove the popup pushing for AMP at runtime?

[IraWatt]

Hey @Genevieve,

Have you tried the batch macro approach to writing to multiple sheets? 

[TonyaS · Accepted solution]

Hi @Genevieve ,

I will share more documentation and links for AMP Engine, but wanted to mention that with AMP it is important that the BUD tool be placed in the branch with the lowest numbered Input tool ID. Here is what is in our documentation:  https://help.alteryx.com/20221/designer/alteryx-engine-and-amp-main-differences 

You can also choose to turn off the pop-up and not show it anymore: 

And here is the additional information about AMP, in case you want to learn more:

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

[TonyaS]

Our Developers were able to make it work with a BUD tool and Outputs to multiple sheets in the same Excel doc. If you still have issues can you possibly send me a workflow that reproduces it? Or provide more information about what type of input data you are using? 

Here's what we did: