Call a workflow from a workflow

I have a workflow that pulls data from an API, parses then stages it into an excel file. Once it completes, I run a 2nd workflow that references the data in the excel file. I then have a 3rd workflow that compares it to another excel file. These all 3 have to be run in that order.

My question is, at the end of workflow 1 how do I call workflow 2, then call workflow 3 when 2 finishes? etc
Thanks for ideas!

Workflow

Accepted answers

All comments

binu_acs

@brwright Chained app will be suitable for your use case

https://community.alteryx.com/t5/Archived-Training/Chained-Apps/td-p/43743

IraWatt

@brwright Or you can use the list runner macro tool or runner tool CReW Macro Support - Alteryx Community. This macro lets you specify from the canvas workflows you want to run and in what order.

IraWatt

@brwright Automated workflows using CrewMacros in Alteryx - Analytics Tuts (analytics-tuts.com) link to how it works

brwright

Thanks I'm going to check these out and I'll let you know if it works for me or if I hit a snag!

davidskaife

Hi @brwright

Is there a particular reason you cannot have all three workflows in one?

brwright

I like to have a definitive start/stop for some of the ways I'm having to make modifications. It keeps me from having to "break" workflows that are fully vetted. One change can waterfall and cause multiple updates and I got tired from that. Now if I want to make a change or just rerun a certain workflow I can without disabling containers etc.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703