community
cancel
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

CategoryString
ADog
ACat
BMouse
BRat
CFish
CFish
CFish
CFish
ADog
ADog

 

Typical Concatenation output grouping on 'Category'

CategoryConcat_String
ADog,Cat,Dog,Dog
BMouse,Rat
CFish,Fish,Fish,Fish

 

Desired output with Unique String Concatenation

CategoryUniq_Concat_String
ACat,Dog
BMouse,Rat
CFish

 

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.

 

Thanks,
Ben