Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

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: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Concatenate-Unique/idi-p/942421

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?

13 - Pulsar
13 - Pulsar

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
7 - Meteor

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.