Call a workflow from a workflow

[brwright]

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!

[binuacs]

@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.

[ArtApa]

Hi @brwright - Here is one more option that you may like: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-run-a-workflow-from-an-event...