Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

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

Writing multiple outputs to one workbook

Jake5
8 - Asteroid

I have a workflow with 3 outputs that need to write to one Excel workbook.  I have prior experience doing this, where I utilize the Block Until Done tool to allow outputs to write in sequence.  However, this is the first time doing this in an upgraded version (2022.3).  For some reason I can't get the full workflow to complete to a good end.  Is this a known issue with version 2022.3?  Any recommended ideas to get around this?  Attached is the error message I'm receiving.  

5 REPLIES 5
alexnajm
17 - Castor
17 - Castor

Are you using AMP Engine? I would turn it off if you are - Workflow Configuration --> Runtime --> deselect "Use AMP Engine"

alexnajm
17 - Castor
17 - Castor

Otherwise yes I would reconfigure it to look something like this:

 

Writing to Multiple Files Snap.PNG

Jake5
8 - Asteroid

Thank you, Alex!  Deselecting AMP Engine did the trick!

alexnajm
17 - Castor
17 - Castor

Fantastic! Long story short, AMP Engine seems to go too fast for the Block Until Done tools - something that hasn't been properly addressed yet due to the parallel processing nature of AMP Engine.

jdminton
12 - Quasar

This has also been fixed in the latest patch for 2023.1. I ran into this last week and was able to get it to work without AMP, but after the patch, it works with AMP as well.

Labels