Free Trial

Alteryx Designer Desktop Discussions

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

How to run workflows in sequential order?

Rinkashime
5 - Atom

Hi! 

 

I consider myself a novice in Alteryx. 

 

I needed help in running my workflows in sequential order.

 

I have 4 workflows that will output 4 excel files. 

 

I want to run it in sequential order in one yxmd. 

 

is that possible?

 

Please let me know and thanks in advance

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

i believe a list runner macro can help you.

 

here there is a video how it works:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/List-Runner/td-p/146703

 

you can download it from here

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740

 

alternatively you can change your workflows and save them as macro.

afterward merge them in one workflow but I think the first solution is more elegant and easier to maintain.

Qiu
21 - Polaris
21 - Polaris

@Rinkashime 
Another possible yet simple way might be using the Block Until Done Tool.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separ...

 

Block.PNG

 

atcodedog05
22 - Nova
22 - Nova

Hi @Rinkashime 

 

Block until done is definitely a solution.

 

Here is a usecase with a similar scenario its writing to 2 different tab of the same file one after other.

If you are not using block until done it might cause file lock issue.

Refer this post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-Excel-with-Join-L-amp-J-in-d...

 

 

atcodedog05_0-1602578789634.png

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

vishalnegi
7 - Meteor

Hi can you please share your worklfow to explain how by can we merge different workflows. and run all in one

Labels
Top Solution Authors