We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

Hello --

 

Many times, I want to summarize data by grouping it, but to really reduce the number of rows, some data needs to be concatenated.

 

The problem is that some data that is group is repeated and concatenating the data will double, triple, or give a large field of concatenated data.

 

As an example:

Name                                         State

ANew York
ANew York
ANew Jersey
BFlorida
BFlorida
BFlorida

 

The above, if we concatenate by State would look like:

ANew York, New York, New Jersey
BFlorida, Florida, Florida

 

What I propose is a new option called Concatenate Unique so I would get:

ANew York, New Jersey
BFlorida

 

This would prevent us from having to use a Regex formula to make the column unique.

 

Thanks,

Seth

15 Comments
terry10
11 - Bolide

This would be very useful!

Ruud
10 - Fireball

One tool would be nice, sure, but the example you're describing is solvable with two Summarize Tools. One has Group By on both dimensions, the other has a Group By and the Concat.

haraldharders
9 - Comet

This idea was already posted previously (https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Concatenate-Distinct-values-in-Summarize-too...). It would be beneficial to combine them.

 

@Ruud: If you want to do uniquely concatenate multiple columns at the same time, the current approach results in:

  • Use two summarize tools for every column
  • Use a row of Join tools to re-combine the output.

That is clumsy and adds unnecessary complexity to the workflow. And I presume it is much slower than an integrated solution could be.

Ruud
10 - Fireball

Not sure if it would be slower, probably. I took a look at your other post about this issue and while not ideal nor close to what this Idea is about, it could be solved a bit more elegant and PEBKAC-safe if you'd build a macro.

prashant007
8 - Asteroid

Though this is a good idea but we should rather have a tool to just remove duplicates instead of adding unique to concatenate or any other tool.

 

If we can have unique values , we can perform other steps too with the unique values

DavidP
17 - Castor
17 - Castor

This idea would also be very handy in the CrossTab tool

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
peterr_h
7 - Meteor

This tool would be useful in Challenge #338 (Challenge #338: Let's Summarize! - Alteryx Community). I saw that the Solution contains multiple repeated Genres for each of the artists, due to concatenating genres from individual albums.

 

The way that I got around this was through a combination of Text-To-Columns, Transposing and Cross-Tabbing, however, I thought that a tool of this sort (or this functionality built into another tool as you've suggested) would be super useful!

gautiergodard
13 - Pulsar

Great idea, and a scenario I come across quite frequently! Agree with @DavidP that this could be expanded nicely into the cross tab tool as well.

smoskowitz
12 - Quasar

Thank you all for your votes -- it seems to be picking up some steam. We all just want to keep making this tool easier to use then it already is.

 

 

Regards,

Seth