Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

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

alexnajm
18 - Pollux
18 - Pollux

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

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

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
Top Solution Authors