community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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,

Alteryx
Alteryx

@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. 

 

raw-xml.png

 

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

 

xml-window.png

 

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

 

summarize-xml.png

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.

Labels