Concatenate Distinct values in 'Summarize' tool

[rohan_tibarewala]

We have 'CountDistinct' and 'Concatenate' options within Summarize tool. 

But 'Concatenate' displays all the instances of value for a Grouped field, this might include lot of duplicates.

It would be great to have an option like 'ConcatDistinct'.

For example - 

Group by 'Branch' and 'ConcatDistinct' Customer should result as Figure 1 instead of Figure 2 - 

Figure 1-

Figure 2-

While this is achievable in different ways currently with a set of tools, but it gets tedious when number of fields is large from which distinct values are to be captured. 

Thank you,

Rohan.

[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. 

[rohan_tibarewala]

@nicole Wow!! So Glad to hear this :).