Free Trial

Alteryx Designer Desktop Discussions

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

Running workflows in Containers one after another

Lumjing
8 - Asteroid

Hi I have two workflows. I run the first workflow and then run the second workflow due to output dependencies. Now I want to have both the workfows put in a container and make it into one workflow and the 1st container should run and complete then the 2nd container should run. Is there any tool or logic to get this. Please see the two containers below with the workflow 

 

 

Lumjing_0-1620230948590.png

 

8 REPLIES 8
JosephSerpis
17 - Castor
17 - Castor

Hi @Lumjing one approach you could take is combining your workflow into a Batch Macro which Enable and Disable Tool containers. You would want the batch macro to run twice enabling a Tool container that contains the contents of 1 in your screenshot first and then on the second run would disable the first tool container and enable a second tool container which holds the contents of 2 in your screenshot. This would be one way of controling the order of execution.

 

Another approach you might consider is the Crew Macro Conditional Runner Tool. More Info can be found here.

apathetichell
19 - Altair

@JosephSerpisTotally curious - is there a reason you would recommend going this route as opposed to just setting up each tool container after Block Until Done anchor and relying upon the BUD to direct traffic?

Lumjing
8 - Asteroid

@apathetichell  I have multiple outputs in container 1 ( all the containers in Red) how can I use block until done tool. 

JosephSerpis
17 - Castor
17 - Castor

Block until Done could be an approach you may want to employ however one of the reason why Alteryx is so fast and proficient is because it pushes data through out the process so by having the workflows combined together you may have issues with the order of execution. Using the two approaches I mentioned would mean it's a bit more clear cut as it keeps the two workflows as two separate processes rather then attempting to combine them.

apathetichell
19 - Altair

@Lumjing @JosephSerpis is much more knowledgeable than me on these matters - so I'd go for his solution.

mceleavey
17 - Castor
17 - Castor

Hi @Lumjing ,

 

In addition to the great points made by @JosephSerpis, you could also have these trigger as chained apps.

In other words, convert the first workflow to an Analytic App, then go into the Interface Designer and upon completion trigger the second workflow. This will allow the first to complete and will then trigger the second on completion with the new output files.

 

Just a thought.

 

M.



Bulien

latimo1
8 - Asteroid

It doesn't work.  I tried it. The 2nd Container starts when the first one does. Which works if you are getting data from different sources, but not if you have to have a sequence of running.

HomesickSurfer
12 - Quasar

Hi @Lumjing 

 

Chaining apps work, however, you cannot schedule the initial app as it requires manual intervention to execute it.  If that is not ideal for your use case, try adding your containers onto a new canvas in the order in which you wish to be executed.  I have had some limited success.  Lemme know if it works.

 

example:

 

HomesickSurfer_0-1673383317882.png

 

Labels
Top Solution Authors