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

Iterative Batch Macro Sample.yxzp

Iterative Batch Macro Sample.xlsx

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.