Can you help simplify a workflow with 12 Record Selects?

Philip

I'm implementing the CDC Historical Limits Method for surveillance of disease detection (reference http://wwwnc.cdc.gov/eid/article/21/2/14-0098_article). I have a successful workflow, but there is one complicated step that I was wondering if could be simplified?

The step is in the Historical Limits Method macro, the second grouping (green) of the attached workflow.

To calculate the value of each month, I go through each month of the last year and take all values from previous months. Right now it involves 12 Select Records tools. It's not onerous, but if they choose to go back 24 months or 36 months, that's a lot of Record Selects to produce. Can anybody thing of a better way?

Historical Limits Method Test.yxzp

KaneG

Hi Phillip,

I would turn everything between the sort and the Union into an Iterative Macro. I have attached what this would look like, with the iterative Macro attached. Run the iterative Macro with your dataset to have a look and make sure that it is the correct data that you are after.

In this case, we use the Iterative Macro design a little differently from normal as we want to feed all the data back in to the Iterative input, up until the number of Iterations hits the Number of Months that we want to go back.. 

Note: I'm not sure if you have implemented it here as the whole lot was packaged to upload, but you can put your supporting Macros in a sub-directory called 'supporting_macros' and then these will not appear on your toolstrip with the main Macro.

Kane

HLM Iterative.yxmc