Concatenate Unique

[smoskowitz]

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

A	New York
A	New York
A	New Jersey
B	Florida
B	Florida
B	Florida

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

A	New York, New York, New Jersey
B	Florida, Florida, Florida

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

A	New York, New Jersey
B	Florida

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

Thanks,

Seth

[NicoleJ]

Great news! There is now an option as of the 25.1 release to Concatenate Distinct values in the Summarize tool! Tom,Tom,Jack,Jack can now be Tom,Jack without the need for additional tools... hooray!! 

NOTE: This is an AMP only option.