Default AMP engine block output to Excel multisheet
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- AMP Engine
- Error Message
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Genevieve,
Have you tried the batch macro approach to writing to multiple sheets?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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/Engine-Works/AMPlify-your-Workflows/ba-p/617590
AlterEverything Podcast: https://community.alteryx.com/t5/Alter-Everything-Podcast/66-The-Alteryx-AMP-Engine-Explained/ba-p/5...
Sr. Product Manager, cloud App Builder
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Sr. Product Manager, cloud App Builder
