Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
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