I have a Batch Macro I'm trying to set up to change the input and output directory based on the user selected country (selected via listbox). I need to add total rows for each file, but when the batch runs, it's totaling records from all files and then adding that total to one of the files. If I add a group by to my summarize tool and then a union, I do get what I expect but it is adding some additional steps.
I thought a Batch Macro would process each file one at a time through the macro, which is what I want because I think that's just easier to understand and to set up for more complicated processing I want to do in the future.
.
Batch macro group by settings
Workflow