Designer: Is it possible to call a macro within a dynamic filter batch macro

Purpose: Searching for a more elegant solution than stringing together a series of filters to call a corresponding macro.

I understand how to create a dynamic filter utilizing control parameters within a batch macro. However, how can I pass that value to dynamically call the macro?

For example, if the control parameter value = "Axx" and the target macro to be called is named "Cleanse_Axx.yxmc":

Is there a way to manipulate an existing tool to perform this action?

Or alter the dynamic filter batch macro XML source to call "Cleanse_{control_param_valu}.yxmc"?

AlteryxDynamicMacroCall_HelpRequest.png

Macros

Batch Macro

Dynamic Processing

Accepted answers

apathetichell

Is your question can you do this - or how do you do this? For "can you change which macro you are calling on the fly?" the answer - is yes... See https://community.alteryx.com/t5/Engine-Works/Dynamic-Hard-Coding-Chained-App-Sorcery/ba-p/764585

You'll basically need to have some kind of chained app where you edit the call to the macro in a flatfile... Have I mentioned that it may be easier to build conditional routing or something to choose which macro to call? To be clear - you cannot directly attach an action tool directly into a macro (and I've tried).

All comments

ChrisTX

Inside the batch macro, update the inner XML. A few examples:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unknown-Select-Feature-w-Summarize-Tool/td-p/327371

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Transpose-Key-Field-Summary-Field/td-p/15755/highlight/true

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Adding-up-columns-for-sum/m-p/381053#M69784

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/List-box-with-Transpose/td-p/514539

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unknown-Select-Feature-w-Summarize-Tool/m-p/327371

Chris

aksmoke

Thanks, Chris. I've reviewed each of the examples, and others that reference the XML update process. However, I am still unable to alter the specific macro to be called. Each of my batch macros are specific to the crosswalk series to be cleansed. So it is not the values\fields within the macro that need to be updated but rather the actual call to the macro. If the control parameter = Axx, call Cleanse_Axx.yxmc; ideally a dynamic solution would facilitate the macro name to be passed in as Cleanse_{control parameter}.yxmc.

According to the following chain, a more elegant (fully supported) workflow option does not exist:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Crew-Macro-Conditional-Runner/td-p/491353

Please let me know if I've overlooked a better solution.

apathetichell

aksmoke

Okay....now that I like! I'll accept as the official solution as soon as I get it running.

Thank you!

apathetichell

fyi - <EngineSettings Macro=".\YOUR MACRO NAME HERE" /> is the specific part of the text file you'll need to edit... .\ refers to the location...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703