This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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.
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.