Macro Design. Processing a list of triggers.

Question

I am reading a list of Active Triggers from a database.

For each trigger I want to pass the trigger value to Macro 1 to decide which process should execute for that trigger.

Once that is decided, I want to pass the trigger values to the Process Macros.  I'd like each of the Processes to be a Macro so that I can add new processes without impacting prior processes.

Repeat until all triggers have been processed.

I've made multiple attempts to build the macro that receives the triggers to no avail.

Any help would be greatly appreciated.

Thank you.

gabrielvilella · Accepted Answer

If you are passing just the control parameter value (trigger), you can enable/disable containers based on those triggers. You can even have multiple processes enabled at the same time if they are independent. I provided an example on how to enable/disable containers here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Trying-to-control-Input-Data-tool-execution-based-on-List-Box/td-p/906253

RquanEvernorth · Accepted Answer

Here's a visual for the solution stated above.

The key is to creates multiple Control Parmeters.

The Action Type is Update Cell.

The Text Input is the Record Layout for the Parameters.

To the right are containers that execute based on the conditions from the parameters.

I join all of the output to funnel the results through a single output.

The Containers could be Macros which can then be created to make the design follow a modular design and minimize the risk of breaking other components.