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 -
![Concat.PNG Concat.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/30445i7549420CFFC6723C/image-size/large?v=v2&px=999)
Group by 'Branch' and 'ConcatDistinct' Customer should result as Figure 1 instead of Figure 2 -
Figure 1-
![Concat1.PNG Concat1.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/30446i29706062583691E3/image-size/large?v=v2&px=999)
Figure 2-
![Concat2.PNG Concat2.PNG](https://community.alteryx.com/t5/image/serverpage/image-id/30447i62B4847F6F8BF5AD/image-size/large?v=v2&px=999)
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.