How to control the order of components execution if I have few of input components at the start of the module?
- 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
I have few subworkflows starts with an input components within a module. How do I control the sequence of the execution of each subworkflow?
- Labels:
- Best Practices
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could use macros to control your processing order, check out this post for more details:
http://alteryx.force.com/alteryxcommunity/AlteryxArticle?id=kA0E00000000VxFKAU
Sr. Manager, Customer Support Engineering
Women & Allies Committee
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In my example, I copy a workbook from a template directory to a target directory and then update it in a subsequent flow within the same module.
1st running step outputs into the APPEND FIELDS tool (Source). All of this activity must complete before appending can happen. Make sure that you only input 1 record/ 1 field into the append field tool.
In my example use case, I have a command prompt running a copy of the workbook occuring and the output going into the append fields Source. The read of another data flow goes into the Target.
The append fields tool is configured with only the Target fields selected.
The result is that I can make certain flows happen first and hold up other processes that Merge into this flow.
Does this help?
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
http://community.alteryx.com/Troubleshooting/Streaming-Modules-to-run-in-sequence
http://www.chaosreignswithin.com/2014/06/blog-macro-pack.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I agree with the 'append' tool. I just have a text tool with one dummy record in it which I connect to the source side of the append tool. After the append tool, I drop that dummy rec. This trick helps to control the flow.
Second, you could look at the Tool ID (in properties > Annotation). Tools with lower number run first, but not sure if that still happens in recent version of Alteryx. I used to copy /paste the tools into a new canvas first - so they would run first.
Third, try the block tool but I never had much luck with it. Some artisans drop 3,4,5 blocks in a row to control the flow but I always thought that was a dirty fix.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @joao,
Have you expanded on the improvements you would like to see in our Ideas section?
I'd encourage you to post your ideas for enhancements for the product to our ideas page. We have some helpful guidelines posted here around writing a post in the ideas section.
If there is anything specific about your use case that you would like help with I'd also encourage you to create a post on the subject or reach out to the support team if you aren't able to post it.
Thanks,
Manager, Technical Account Management | Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @dhydrated
This is a common issue, especially where you're prepping data in one flow, then need to join to it in the second.
The way we get around this is to wrap them in Batch Macros. From my understanding, Batch Macros are unique in that they isolate the flow of processing from the next step.
There are a good few ideas in the Ideas section about controlling flow (e.g. https://community.alteryx.com/t5/Alteryx-Product-Ideas/Control-Order-of-Execution-of-Workflow-Object...) - so it's well worth giving your views and your pain points on the ideas section to provide the Alteryx team with input and feedback from the community and user base
BTW - let me know if we need to mock this up to help you?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think Joao's comment is a pretty reasonable one. The question was first asked four years ago (and I can find others asking this often online), and yet such basic functionality is still not forthcoming.
If we need to tell Alteryx what it should look like, then here goes:
In the workflow configuration pane, add a tab for execution order. For guidance on what it should look like, take a look at how photoshop handles layers. The layers that you drag higher up are the layers that are on top. In alteryx, you should be able to drag workflow items/tools higher in the list to specify which runs first. Place a small icon on the list elements that shows an image of what tool it is. Show the specific tool number next to the icon and tool name. When you click on that tool in the execution order list, have the corresponding tool in the workflow highlight so that users can quickly see which one it is.
And with that, it's time to add the functionality into the software.