The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Concatenate Unique Method for Summarize tool

Lots of use cases involve concatenating some values based on group by clauses within the Summarize tool.

It will be great to have the option to Concatenate Unique as an aggregation method, so the results will have just one appearance for each value in the results.

Plus, having the option to get the chance to have them sorted or not will be awesome.

17 - Castor

Would definitely like to see this! Looks like there's already an open suggestion that's 'Accepting Votes' here:

16 - Nebula
16 - Nebula

I often have to use 2 summarize tools to accomplish this. However, 9 out of 10 times it's after I realized that I forgot to do it (I notice this by seeing the output).   Adding this option would be a time saver for sure!

12 - Quasar
12 - Quasar

Simple and powerful idea!

15 - Aurora
15 - Aurora


Thanks for pointing that out. I searched for this in ideas, but results didn't show, that's why I created this.

Maybe the community team can merge both posts?

14 - Magnetar
14 - Magnetar

Merging posts is a good one to join the same or very similar ideas as @Hollingsworth can attest with our respective find missing macro ideas getting merged and then moving to the next status! 


An upvote from me, as so many times I’ve done two summarize tools chained together (group by [1], group by [2]. Then group by [1], concat [2]).

13 - Pulsar

Great idea! Definitely a scenario I've come across frequently ! 

Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
8 - Asteroid

Hi, this has already been submitted here: Concatenate Unique - Alteryx Community


I'd recommend merging these as they're the same suggestion.

17 - Castor
17 - Castor

Fully agree @Aguisande - there are a few of these kind of cases which would be very useful.


As you say, there is already a countDistinct but not a concat distinct.