Iterative Process within Batch Macro

[knnwndlm]

Hi SME, 

I have a workflow that's reallocating any negative value to one year forward and one year backward setting the 1 year backward/forward to zero if they're negative.  This is shown in the three examples shown in the Excel file.

What I struggle with is the case where I have more than one year with negative values in a given tile.  If I were to filter for tile #3, then my batch macro would work since it only has to deal with one negative amount to be re-allocated.  If I were to filter it for tile #2, then I would run issues of having to figure out how to deal with multiple negative items to be re-allocated (rows 6 & 7).

I was thinking of using an Iterative macro to embed in this Batch macro to see if that works.  Any suggestions?

Thanks,

kwl

[ashleyharvey19]

Working with batch macros in an iterative way can get confusing fast, especially when the tool keeps looping without producing the expected output. I like how the thread breaks down the need to separate iteration logic from the batch process itself. Building a smaller prototype flow first usually helps spot where the macro hands data back, so you can adjust the interface tools before scaling the whole thing up.