Dynamically Choose Fields In Summarize Tool

Hi all,

I am looking for a way dynamically choose fields to add to a summarize tool. The Action tool (in a custom macro) can be used to dynamic update several different tools, but it doesn't seem to offer the feature of adding fields to the summarize tool.

Another viable solution that would work is to dynamically remove fields in the summarize tool, since I can by default choose all the fields I want to use, and dynamically remove field(s) for each iteration.

Does anyone have any experience with this, or have a workaround? Thanks for the help in advance.

Workflow

Common Use Cases

Batch Macro

Dynamic Processing

Iterative Macro

Accepted answers

MichalM

@akihirokomatsu

What @Thableaus suggested is definitely an option. An alternative would be to use the macro approach and set the Action too to Update Raw XML with Formula.

You will need to build out the XML part upstream and pass it in as a control parameter. If you want to see the XML structure the Summarize tool uses, you can enable this option under Option > User Settings > Edit User Settings > Advanced > Display XML in Properties Window

Once enabled, you will be able to access the xml in the configuration panel.

All comments

Thableaus

Hi @akihirokomatsu

What about transposing your fields before Summarizing them? Sometimes this can be useful since the Transpose Tool allows the option to "Dynamic/Unknown Fields" and it would automatically transpose any new Field.

It really depends on your data.

Cheers,

MichalM

@akihirokomatsu

What @Thableaus suggested is definitely an option. An alternative would be to use the macro approach and set the Action too to Update Raw XML with Formula.

Once enabled, you will be able to access the xml in the configuration panel.

akihirokomatsu

Thanks for the fast response. If, for example, I had two fields that I wanted to group by interchangeably, City and State, in the summarize tool, how would I do that? I am curious to see if I can get around using two different summarize tools to do so.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703