Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
BrettMRP
5 - Atom

Use the "Block until done" tool

CMS
5 - Atom

Hi BrettMRP,

 

For simple cases and when inputs are physically separated from outputs (e.g., Excel, CSV, Input/Output directories), the block until done is the way to go. However, for more advanced scenarios such as reading tables from a database, doing something with the data and then updating back the tables, this tool falls short. Things get even more complicated if within the tables you have foreign key constraints that prevent you from just dumping the data. 

 

Continuing the database example, it's not possible to add data to a table and then obtain the updated IDs so you can properly insert child records that depend on these IDs. Are there workarounds? Clearly yes, not using block until done by the way, but by controlling the IDs. This workaround is an overhead compared to other technologies and it's also a bad programming practice as the database should be the one controlling the IDs. That's why you have autonumber in Access, identity in SQL Server, etc.

 

Regards,

Carlos.  

erikasuzuki
5 - Atom

It's 2022 now and there's still no elegant way to control the order of execution. Block until done is fine, but it only accepts one input. And if you need more than that, you need to chain a lot of it. In some scenarios where input is not applicable or if your data source are from multiple places, it can be a pain.
So why don't you make it accept multiple inputs, and then inside the configuration, let us drag and drop the order of how we want to execute it. 

And for the output, let us configure which output anchor to map to. If output anchor is not mapped, then it will be set based on the positioning/order of the items in the input list.

rhipp87
8 - Asteroid

Alteryx needs to continue to the subsequent flow and run if there are no input fields for the user. Or even continue after X seconds and no inputs.

ajayrentala
5 - Atom

Simple solution is turn off AMP, it will follow flow control 

SeanAdams
17 - Castor
17 - Castor

Have  you tried the Control containers that were delivered in 2023?

Control Containers: Take Control of Your Workflow - Alteryx Community

 

 

Labels