2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Ideas

Share your Designer 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

5 Comments
terry10
11 - Bolide

This would be very useful!

Ruud
9 - Comet

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

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
9 - Comet

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

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