ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Using Text Input for Summarize Field selection

Huyly0325
5 - Atom

I have 17 different attributes (columns) and 1 value column in my dataset. I'm looking for a dynamic way of summarizing the data based on the attribute names from a text input. For example, If I want to select only 5 attributes as fields in the Summarize tool, I don't need to manually change it. The Summarize tool will take the field values from the Attribute Names in the Text Input. I plan to do at least 10 different attribute combinations so using Text Input to manage those combinations. Is it possible?

 

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Huyly0325 
Maybe I am overdoing it again 😊.
The idea to reassign an Empty value to the non-used columns after matching the text input specified columns so the unused the columns will take no significance during the grouping.

Then use the Multi-field Formula and Cleasing Tool to remove the unnecessary columns.

1211-Huyly0325.jpg

Huyly0325
5 - Atom

Thank you so much! It works

Labels
Top Solution Authors