Batcho Macro only running one batch

Question

So, I have a workflow that I am trying to utilize my first batch macro on.  There's more than what's shown in order to get to the inputs, but I have attached the necessary files.  Basically I have data for 3 locations (far left column is location):

ORGAMEX1000ORGDISC1000ORGMC_V1000ORNAMEX2000ORNDISC2000ORNMC_V2000ORTAMEX3000ORTDISC3000ORTMC_V3000

And I want to run a batch macro that performs an output for the locations one at a time.  The only thing in my batch macro is a filter tool that has the specific string related to Location being changed.

For some reason, when I run the workflow, it only runs it for the criteria I originally put in the filter tool rather than dynamically changing the filter criteria.  The goal is to get a different sheet in my output for each location - so ideally 3 sheets in one excel file (this part is done outside the macro though).

Probably an easy fix, but many of the batch macro tutorials I have seen haven't really helped to troubleshoot this.

Thanks in advance!

Example Macro.yxmc

Support Example - Batch Macro.yxmd

JosephSerpis · Accepted Answer

Hi @Slushercw I edited your macro you were nearly there just had to change the configuration. There is alternative to using a batch macro to write to the same location and create different sheets if your output is an excel file. I have included that alternative method in the attached workflow.

TerryT · Accepted Answer

I think your ACTION tool may be the issue.

It looks like it is configured to update the CUSTOM FILTER expression of the FILTER tool, but the FILTER tool is configured as a BASIC FILTER (Simple mode), so we have to dig into the SIMPLE section and update the Operand - value="ORG"

Hope this helps.

Terry T

Paulteryx · Accepted Answer

Sorry for the initial confusion, try selecting Operand in your Action tool.