Using Loop to change the "Group by" field in "Summarize" Tool in each iteration

Question

Hi guys!

I have this scenario in which I need to output multiple tables in one excel sheet. Each table is grouped by a different dimension. Currently my workflow looks like this -

Each "Summarize" tool has a different group by field. Is there a way we can use only one "Summarize" tool and use loops instead to make the workflow run for a different group by field in each iteration?

Attaching the workflow for reference.

Any help would be great!

Thanks,

Roopan

changing fields_loop.yxmd

Qiu · Answer

@rs1 
Yes, agree.
Myself is not satisfying with this either.

Sorry.😁

rs1 · Answer

Hi @Qiu

Thank you so much for your efforts.

I am looking to avoid any branching in the workflow. This surely eliminates the branching at summarize tool, but again branching is required at the select tool.

Wondering if it can be done using Interface tools.

Roopan

Qiu · Answer

@rs1 
Hoestly, I am not happy with this one also, but maybe you can have some hints.

Was not able to control the field sequence if I put the Table tool inside macro.

changing fields_loop.yxzp