Default AMP engine block output to Excel multisheet

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?

Error Message

Output

AMP Engine

AMP-Engine

Accepted answers

Tonya_Smith

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

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

All comments

IraWatt

Hey @Genevieve,

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

Tonya_Smith

Hi @Genevieve ,

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

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

Tonya_Smith

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:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703