Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to call another workflow with dynamic parameters?

khk403
5 - Atom

Hello,

 

I have question about automatically running two diffrent worklfows.

if the workflow #1 is finished, I want to make workflow #2 run automatically. (without user input)

 

[structure]

1. workflow #1 - saved in folder #1

2. workflow #2 -  saved in folder #2

(workflow #2 is just only one and it must be Initialized after finished)

 

 

[process]

1. create output file of workflow #1 

2. execute workflow #2 (input file of workflow #2 is output file of workflow #1)

 

I would like to know how to call workflow #2 with output file of workflow #1 

it must need dynamic parameter for calling output file of workflow #1 

 

please let me know how to solve these problems.

Thanks. :)

 

5 REPLIES 5
KGT
11 - Bolide

Do you need to pass a parameter to the 2nd workflow?

If not, then a chained app should work, otherwise set an event on the first workflow to run the 2nd workflow by run command.

 

If you do, then you're going to either need server and use the API to coordinate, or wind up with a convoluted process. I advise putting that parameter in a file as well, rather than trying to pass it directly in desktop designer.

 

Last option, and probably the most common is the CReW Runner Macros. Info here as well: CReW Runner Macros.

khk403
5 - Atom

Thanks for replying.

 

I need to pass a parameter to the 2nd workflow.

because 2nd workflow is master file (just only one) 

Each of 1st workflows will call 2nd workflow with parameter(client number)

 

how can i pass the parameter to run 2nd workflow?

KGT
11 - Bolide

The Desktop Designer will not allow you to pass a parameter to another workflow. You would need server and the API for that.

 

Your options are:

  • Make the 2nd workflow into a macro and put it in the first workflow.
  • Output the parameter to a file that the 2nd workflow picks up and use one of the aforementioned methods.
  • Look at 3rd party orchestration.
khk403
5 - Atom

Thanks for letting me know.

 

Except your options, Is there any way of using batch file (.bat) to pass parameter?

KGT
11 - Bolide

You would need an app for that to work. By App, I mean a yxwz file, it's a workflow with parameters.

There used to be a way to make an app (yxwz) and pass parameters to that via a batch file, maybe even using a yxwv file (wizard values). I'm not sure if that was because I had a higher level license with scheduling or not at that time (probably 8 years ago) but if you can kick off an app via cmd then you should be fine to explore that.

Labels