"Parent Child" Macro Runtime

[jeffgordon]

Hello, 

I am trying to find a way to reduce run time for my Bill of Materials macro (currently a couple days) with a data set around 290000 records. Currently I have to run each parent through individually to find levels of children. Keep in mind that additional parents can be noticed through 4 levels. Here is my current process. Thoughts?

[clmc9601]

Hi @jeffgordon,

This yxmc looks like a candidate for an iterative macro nested within a batch macro. I drafted an idea of this the best I could without access to the data. I believe it encapsulates all the tools you were using within your macro in a slightly more efficient format. I'm pretty sure this will improve your runtime, although it will make it more difficult to troubleshoot. You'll probably need to do some adjusting before actually using this workflow since I didn't actually run it. Depending on how many iterations you want it to do, you might need to add in a maximum number of iterations on a filter or something.

Other options for reducing runtime can include reducing data sizes, like doubles into floats and autofielding strings.

Workflow with batch macroBatch macro containing iterative macroIterative macro