Iterative Macro with Filter

MaPerez

Greetings,

I have this workflow to calculate a score with a decision tree. I need this process to be iterative througth the stores number... I mean:

I have three stores 100, 101 and 102.

First calculate score for the store 100, second for the store 101 and third for the 102. All these result should be saved in a single file.

I did this process but with a filter using a text box tool but I have to manually write the stores (and I need to make the score automatically)

Can anyone help me?

Decision tree.yxwz

NicoleJohnson

Try a batch macro! You will need two inputs to feed into the batch macro - one with the data, and one with a summarized list of store numbers that will feed into the upside ? after your macro is inserted into your workflow. In the macro itself, you configure the Control Parameter to be the value that your filter uses, rather than hard-coding the number - see formula configuration below. Then the rest of your workflow would perform the calculations as desired and output the results in a single file (use a Macro output tool if you want to use those results in the rest of your main workflow.) 

Hope that helps point you in the right direction? Let us know if further clarification is needed!

Cheers!

NJ

challenge_112_NicoleJohnson.yxmd