Batch Macro Not Updating Filter Tool

[dmpope]

Hi everyone,

I created a batch macro to update a filter tool with a set of record IDs I added to my data input. The filter tool takes the starting record ID and the ending record ID and filters on all of the data between the two. I have 40 batches of record IDs/data that this macro needs to process. However, the macro is only taking in the first set of IDs. Below is how I have everything configured:

The record IDs in a join tool in the workflow, connected to the Control Parameter anchor for the macro:

The Control Parameters & Actions tools connected to the Filter tool

Config of Control Parameters

Filter tool formula

Could someone let me know what I need to fix in order for this to go through all 40 record IDs?

Edit to add:

For the macro config in the workflow itself, I've tried every combination in the GroupBy tab and it's given me the same results or nothing.

And the Questions tab have the correct columns selected for each Control Parameter tool.

Thank you!

[dmpope · Accepted solution]

Adding a reply just in case people find this later - there was nothing wrong with how I set up this batch macro, it was a formula nested in one of the formula tools within my macro that was causing my data to bundle under one bank ID which made me think it was only going through the first set of record IDs.