Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to control the order of components execution if I have few of input components at the start of the module?

dhydrated
6 - Meteoroid

I have few subworkflows starts with an input components within a module. How do I control the sequence of the execution of each subworkflow?

25 REPLIES 25
MargaritaW
Alteryx Alumni (Retired)
Greetings,

You could use macros to control your processing order, check out this post for more details:

http://alteryx.force.com/alteryxcommunity/AlteryxArticle?id=kA0E00000000VxFKAU
Margarita Wilshire
Sr. Manager, Customer Support Engineering
Women & Allies Committee


Alteryx, Inc.
Ned
Alteryx Alumni (Retired)
You can't control the order of processing in all situations, even when the technique described above.  In order to optimize the porcessing of a module, Alteryx forces some inputs to run before others, even if they are included in macros.  An example of this is inputs attched to the right side of a SpatialMatch or a FindReplace, even indirectly.  The module runs more efficiently if those come before other inputs.
mark_frisch
7 - Meteor
I do control the process subflows by using AppendFields.

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
borys_tyukin
5 - Atom
Alteryx Runner macro created by Adam Riley  might be a good solution - check this post
http://community.alteryx.com/Troubleshooting/Streaming-Modules-to-run-in-sequence
http://www.chaosreignswithin.com/2014/06/blog-macro-pack.html


 
simon
11 - Bolide

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.

joao
8 - Asteroid
These hacks to make up for basic product functionality leave me stunned!
JessicaS
Alteryx Alumni (Retired)

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,

Jess Silveri
Manager, Technical Account Management | Alteryx
SeanAdams
17 - Castor
17 - Castor

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?

zebing
7 - Meteor

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.

Labels