Solutions to trigger other workflows

[cutehappybear]

Hello everyone,

What kind of solutions are available to trigger other workflows inside my workflow?

My requirements:

• Possible using Alteryx Server (not all macros are supported, so...)
• I want it to be possible that one workflow outputs data that can then be used as the input in the following workflow, and so on and so forth

Thank you very much!

[AngelosPachis]

Hi @cutehappybear ,

I think the answer to your question would be the Runner macro included in the Crew macros package.

https://www.thedataschool.com.au/tushar-pulipparambil/crew-macros-easing-your-alteryx-workflows-jour....

That will allow you to run multiple workflow in success and the macro can be used in Alteryx server.

[cutehappybear]

@AngelosPachisHello Angelos, one of the first things I read in that page is "As per the Alteryx support site, the CReW Runner macros (Runner, Conditional Runner and List Runner) are the only CReW macros supported by Alteryx, but Alteryx Designer ONLY. These macros are not supported when used on Alteryx Server, Alteryx Designer + Scheduler or AAH. " 😔 so unfortunately, doesn't look like it can be used in Alteryx server.

[JarekSkudrzyk]

@cutehappybear 

hi, have you tried analytic apps? they allow to run other apps after successfully running the previous one
https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

[AngelosPachis]

Seems you are right @cutehappybear although I'm sure I've used them at some point with Alteryx Server.

Alteryx API seems like an alternative if all workflows are published on the server. Maybe this  blog helps to demystify the topic a little bit

Server Runner Macros - Alteryx Community

[ashishabhishek]

Hi,

You can use Events from workflow configuration window to trigger an event after the workflow has completed successfully and locate a batch that would run the workflow. Regarding taking input from previous workflow, you write the output from your first worklow to a yxdb and use it as input in your next workflow. https://help.alteryx.com/20223/designer/run-workflows-command-line 

1. Create a batch script using this command 

AlteryxEngineCmd.exe [WORKFLOWLOCATION]\[WORKFLOWNAMEHERE].yxmd

2. goto the events tab in the workflow configuration

3. Add-> Run Command -> Run Event when: "After Run Without Errors"

4.  Locate the batch script 

and then schedule it on server.

Hope it helps.

Thanks,

Ashish