Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

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

Use Containers in a sequential way

10 - Fireball

Hello to everyone.


I´m starting using alteryx and I have the following question.

Let´s say that I have Container A which creates a database that Container B uses to create an Excel output.

I´m trying to work this in a sequential way.


Any solutions?

17 - Castor
17 - Castor

Hey @neromerob,

Sounds like you could try use the Block until done tool. It wont do the second output till the first is finished 



9 - Comet

@neromerob ,


I'm assuming the containers represent two independent flows of tools.  Regardless of the use, if you have an order in which you need to enforce execution and block until done tool can't help you out then you can achieve this with a Macro.


It's actually a relatively simple approach.  And even if you don't have much experience with Macros would make for a fun first dive into Macros.


In a nutshell, you're going to convert your existing workflow into a Macro and use an outer workflow to pass in true/false values to disable/enable the containers as you need per iteration.


I can't upload workflows from my work computer so I'll write out the approach:


Part I: The .yxmd workflow(AKA what I referenced as the outer workflow)


This will involve only 2 tools.


First, a text Input tool with a table that looks like this:


Execution SequenceContainer AContainer B


Second, the Macro  you are about to create.  The configuration here will involve mapping Container A column to the Control Parameter connected to your container A and the Container B column to the Control Parameter connect to your container B inside the Macro.


Part II: The .yxmc workflow (AKA the Macro)  will involve minimal adjustments to your existing workflow.


First, you'll need to add two control parameters.  The first Control Parameter will be connected to Container A, the second Control Parameter will be connected to Container B.  When connecting the Control Parameter, connect the Q icon to the Lightning Bolt icon on the container.


Second, you will notice two Action Tools have appeared between the Control Parameters and the Containers.  The configuration will be the same for both.  Click on the Action Tool, expand the Disabled section and click on the words value - value='False'.  This will highlight that section.  That is all the config you will need to do.  Note: Select an action type should reflect the default value "Update Value".



If you run the outer workflow you will see two iterations run (because you have two rows in the text input tool) that has passed the appropriate True/False values into the Macro to disable and enable the relevant containers.  You could expand this further if you had three containers or more.  However, I'll stop right there for now.


Good luck.

13 - Pulsar
13 - Pulsar

Hi @neromerob!


Another approach would be to utilize the Parallel Block Until Done Crew Macro. It's a nifty tool I use often.


It is very similar to Block Until Done, but instead of having one input and three outputs, there are two inputs and two outputs. Stream A will complete before stream B  begins. If you have more than 2 streams of data, you can stack multiple tools to control the order execution.


Capture (1).JPG


You can download this and other Crew Macros here:



I am also attaching a packaged workflow with the macro. Let us know if this helps!



5 - Atom

Here is a blog that discusses what @DQAUDIT replied - I was able to make it work using control parameters by adding the conditional tools

Dynamically enabling / disabling workflow sections 





Hi @neromerob 


The Designer team is currently planning to add a new type of container that allows for container sequencing. Planning it to be added to the GA 23.1 release in the spring.

5 - Atom

That is awesome news! Looking forward to this update!