Running multiple alteryx workflows within alteryx

[vkirkov98]

Hi!

I have multiple workflows and scripts what I would like to run through one Alteryx workflow.

1. I run a workflow using Runner.

2. I use Block until done to wait for every step to be completed

3. Running a .bat file to pull inputs from SAP using Run Command

4. Killing open Excel files by running a .bat file using again Run Command.

(until this step everything is working fine)

5. Here I wanted to run 4 other Alteryx workflows of which only the first one is needed for 2 of the others. I put the filepath of the .yxdb files in a Conditional Runner tool. Even the first workflow from the mentioned 4 do not have a result, although if I run it separately entering the workflow that is working. 

Question: Do you have an advice how to run those 4 additional workflows or why my idea is not working?

Thanks,
Valentin

[acotta17]

Hi vkirkov98,

If I’ve understood your query correctly, here are a couple of suggestions you could try:

1. Use Runner + Block Until Done
Since you’re trying to sequence workflows where one output feeds into others, chaining every output using the Runner tool along with Block Until Done might help.

2. Avoid Conditional Logic If Timing is the Issue
If the Conditional Runner is failing due to output files not being generated in time, run them in sequence — not based on file-checking — unless you really need conditional branching.

Let me know if this helps

[Pilsner · Accepted solution]

Hello @vkirkov98 

One way you could tackle this would be to use control containers, with just the normal runner macro inside. You can include logic such that each workflow only runs if the previous one was successful. I have created an example in the image below.

Please let me know how you get on.

Kind regards - Pilsner

[KGT]

Something else that I'll mention here that may affect the BUD.

The Runner tool does not function as a part of the workflow, so when the data sends to a Runner tool, it's executed as a separate process, not as a part of that workflow. This means the BUD knows even less about what else is happening.

[vkirkov98]

Hey Pilsner,

Thank you for your help, I tried it and it seems working. I will looking with curiosity in the upcoming period and if something is incorrect I will come back, but for now it looks like it is a good solution.

Best,

Valentin

[Pilsner]

Hello @vkirkov98 

Glad I could help! If you do run into any issues, feel free to @ me and I'll do my best to assist. 

Regards - Pilsner