Chaining

Hi all,

Hoping you can advise. I have 14 quite complex data flows. They are to be run one after the other. However, I don’t want the end client to run them manually one by one. I’d rather they click one button and the process runs and executed each of the 14 data flows one after the other automatically. How can this be done, can I chain them somehow?

Regards,

Rev

Workflow

Accepted answers

danilang

Hi @RevlinAbbi

Using the various Crews runner macros works well if you're running from the Scheduler or in Designer, but they don't work when running from the gallery.

On the gallery you can get around this by using the built functionality to be able to chain a series of workflows together. On the Workflow tab of the Workflow - Configuration screen, change type of your workflows to Analytic App.

Once you do this, go into the Interface Designer, clear on the gear and check "On Success - Run Another Analytic App".

and enter the name of the workflow to run.

Check out this post for an interactive lesson on chaining apps

Dan

All comments

andyuttley

Hi @RevlinAbbi

The CREW Runner Macros are great for this kind of use case:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-the-Runner-Macro-Chaining-Workflows-Caching-Data-How-To/td-p/70550

Do you have / able to have those macros installed?

Andy

rafalolbert

Hi @RevlinAbbi,

My best recommendation would be for you to use CREW macro pack and the 2 specific tools that you could consider are: Runner and Conditional Runner.

This way you can chain a series of workflows and make execution of later steps dependent of success of the proceeding ones.

If you don't care about successful executions of previous steps you can use List Runner.

You can download macros from here: http://www.chaosreignswithin.com/p/macros.html

This provides an intuition of how this looks like (attached workflow is to get you started - please reference your own workflows respectively) - logs are collected and the email gives you clarity of where things break, when they do.

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

workflow.yxmd

danilang

Hi @RevlinAbbi

Using the various Crews runner macros works well if you're running from the Scheduler or in Designer, but they don't work when running from the gallery.

Once you do this, go into the Interface Designer, clear on the gear and check "On Success - Run Another Analytic App".

and enter the name of the workflow to run.

Check out this post for an interactive lesson on chaining apps

Dan

RevlinAbbi

This looks like this will be appropriate. I’ve just downloaded the four workflows (workflow1-input, workflow2-process, etc) and the final workflow. I can run each of the workflows but the runall workflow isn’t running. It has an error saying “the entry point is invalid”. So I’m not sure who this runall workflow is able to run the other 4 workflows. Does this example work for anyone else?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703