Load Workflow sequentially or in order
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We have database which have more than 50 tables including some lookup tables. We created workflow for each table to migrate data in database and it's working fine. Now i want make on task or schedular which load lookups first and than main. Is there any way can we create such one task or workflow or schedular that includes all the table.
Your support is highly appriciated
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
the easiest way is to put them all on one workflow and use Control Containers to determine the run sequence.
You can find out more about Control Containers here:
https://help.alteryx.com/20231/designer/control-container-tool
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jamshed07 , so you have one workflow for each table, and you want to run them in a certain order? Have a look at the 'List Runner' macro made by CReW. This macro takes a list of Alteryx workflows as an input, and then runs them sequentially. It will also output the logs from each run. You can download CReW macros here: http://www.chaosreignswithin.com/p/macros.html
