Concatenate Unique Method for Summarize tool

[Aguisande]

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.

[DataNath]

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

[mbarone]

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!

[Hollingsworth]

Simple and powerful idea!

[Aguisande]

@DataNath 

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?

[cgoodman3]

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]).

[gautiergodard]

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

[peterr_h]

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

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

[SeanAdams]

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.