Running two workflows one after the other

[Meiye]

Hi all, 

I have two workflows, the first one process and produce 3 excel files with the Render tool, and the second process some other stuff and eventually send an email with the three files from the first workflow attached.

I'm wondering if there is a way to have the second flow run when the first is done running. I don't think there is a way to use block until done because the second workflow has like 8 different inputs. Not sure how this can work with a chained app since there is no need for interactions. 

Until now I've just been manually running both of them in the server, but it will soon be passed towards a non technical person, so I would rather that they only need to press one "Run" button instead of two. 

Appreciate any input.

Thanks,

Meiye

[DataNath · Accepted solution]

Hey @Meiye - a couple of suggestions here, depending on what you have available.

1) If you're using Alteryx Designer (your Alteryx Server will also need to be on the same version) with 2023.1 then you'll have access to Control Containers. Using these, you could bring the workflows together in one, placing them in a CC each, with the second dependent on the first finishing. More info here: https://help.alteryx.com/current/en/designer/tools/developer/control-container-tool.html

2) If you're on an older version, then you could look into using the List Runners macro which is part of the CReW Macro pack - a great article here on how to chain workflows using these: https://knowledge.alteryx.com/index/s/article/Chaining-Workflows-Together-1583460632768