How to create a batch macro with 2 control inputs to enable/disable containers per inputs

Question

Hi,

I am creating a batch macro that checks input from a reference file. If the flag is true for the particular file name only then its input tool should work in the macro.

I'm struggling to make this logic as i have to mention a combination of file name and flag.

Ref file structure

File NameFlagAccountTrueCustomerFalseProductTrue

Please refer the attache images of macro and main workflow. I want to use 2 inputs in batach workflow, right now i have only 1. The control parameter (flag or threshold value to check if it is true or false. But along with this, I need the file name as well to control separate containers according to the file and flag combination

Could anyonone take a look at this please?

Thanks in advance

Nancy

Main workflow.PNG

Macro_snip.PNG

apathetichell · Answer

Take a look at these - one is an App version (check out the interface designer settings) the other is a macro version (takes a boolean field and a string of a fieldname) using two control parameters.

optional file - app verison.yxzp

optional file - macro version.yxzp

OllieClarke · Answer

Hey @NancyS

If you update the value via formula, and connect both control parameters to the action tool, you can reference them independently in your formula - something like this:

Hope that helps,

Ollie

NancyS · Answer

Hi @apathetichell , thanks for sharing this. It helps as in to understand the idea of batch macros' functioning. However, I'm facing issues with the choice of tools.. For example, i want to create a condition, on the basis of which the containers can be enabled or disabled. If I take Control Parameter's input as "True" or "False" This should work, but apart from this True or False condition, I need to have the name of the input file as well, based on the combination value of File Name and Flag value (True/False), the containers should be enabled or disabled.

What I've tried.. I've used condition interface tool. But the problem is.. for condition tool to properly work, we have the option of Control Parameter as input. In this case, I'm not able to pass only column (Flag Value- True/False). My aim is to work with both fields File Name and Flag Value in order to control the containers.

The solution i tried is referenced from here: Dynamically enabling / disabling workflow sections - Alteryx Community