Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Summarize Tool | Unique String Concatenate

When using the Summarize Tool please provide a grouping action that does a unique string concatenation. Example below. 


Input table

Category String
A Dog
A Cat
B Mouse
B Rat
C Fish
C Fish
C Fish
C Fish
A Dog
A Dog


Typical Concatenation output grouping on 'Category'

Category Concat_String
A Dog,Cat,Dog,Dog
B Mouse,Rat
C Fish,Fish,Fish,Fish


Desired output with Unique String Concatenation

Category Uniq_Concat_String
A Cat,Dog
B Mouse,Rat
C Fish


I realize that this can be done with two inline Summarize tools but getting this done in one tool will streamline a workflow.

1 Comment
Alteryx Alumni (Retired)
Status changed to: Under Review

 The Summarize tool is one that is very powerful but often harder to understand by new users within the product.  We would like to overhaul the tool and reduce the common use cases where two summarizes are necessary as well as provide options for exploring the data without using multiple parallel Summarize tools.  We will consider this request as we begin to look at simplifying the tool.