Build a batch macro that runs for each value in a field

Hi!

How can I build a batch macro that runs for each company sector? Basically, I have three fields as an input - a company ID, a sector ID where the company belongs and a numeric variable (financial ratio). The output should be a rank attributed to each variable (and the workflow for that is already done - attached). So what I need to know is what's missing on my workflow in order to have the values for all sectors... I've built a filter and using a control parameter to update the value in this filter...

Thank you in advance.

macro_ranks_empresa_no_setor_v0.3.yxmc

Batch Macro

Accepted answers

philipmannering

Hi @sarasustelosantos

This batch macro now needs to be used in another workflow (which I've attached). I've set up the macro to run once for each Setor, hence the Summarize Tool grouping by Setor. See attached.

Batch macro.yxzp

All comments

philipmannering

Hi @sarasustelosantos

This batch macro now needs to be used in another workflow (which I've attached). I've set up the macro to run once for each Setor, hence the Summarize Tool grouping by Setor. See attached.

Batch macro.yxzp

philipmannering

I'm not sure exactly what your macro is doing, but there is a simpler way to create this rank by Setor by checking to Group By Setor in the Mult-Row Tool. See potential alternative solution attached.

Best,

Batch macro alternative.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703