Iterative Macro multiple outputs help

Lance_In_My_Pants

The intent of this work flow is to randomly select a Test_DMA along with the 2 highest ranked Control_DMA. Then to create a list of of the Test_DMA and 2 Control_DMA's and remove them from the original data set and then repeat the process. I am currently stuck on how to aggregate the list dma's used to remove from the original data set, my guess is I need to create another macro input/output but I was unable to get it to work.

Test_Final_Selection_wMacro.yxzp

CharlieS

I haven't looked at your attached module, but here's what I do in assignment scenarios like this.

If you have a list of DMAs feeding into the iterative macro, use a formula tool to create a variable before the macro that will be updated in your macro. This variable (let's call it "FLAG") will start out with null/0 values. As the iterative macro runs, the value of "FLAG" will be updated each iteration. Each new iteration starts by filtering record where "FLAG"=null/0 to make new assignments (aka updates to "FLAG" values) before getting unioned back to the input records each time. If you want to assign all the DMAs, have the loop output filter to any DMA records where "FLAG"=null/0.

I hope this helps.