Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Run Multiple Workflows Simultaneously After Main Workflow Runs

Highlighted
7 - Meteor

Let's say I have Workflow A which creates Table A.  Then I want to run 10 workflows at the same time immediately after Workflow A in which each of these subsequent workflows would use Table A to join up its own unique data source. So the idea would be to save time in lieu of having one workflow having to wait for each input tool to extract the data.

 

I would want this to be scheduled on the server which prevents me from using CREW macros.

 

I also don't believe chained analytic apps would be useful since I want these workflows to run at the same time.

 

Is there any way it's possible to do this?  I recall at the conference last year there would be sequencing schedules in future releases that I think would apply in my situation but I haven't seen anything like that yet.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@kpuser 

 

A few thoughts:

 

1.  CReW macros run on the server. 
2.  There are physical limits to running to many jobs concurrently. 
3.  If 10 jobs read table A, it is likely more performant  to run 1 job that reads it and to perform 10 writes. 

especially when table a is huge, read it once and join away. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.