Aggregate: Concatenate options (distinct & separator) [DONE]

The Concatenate option under aggregate would be more useful with the following options:

  1. Ability to specify a separator. It would be great to be able to concatenate and separate the values with a comma or pipe or even space. Example. ABC DEF GHI
  2. Ability to concatenate distinct values. This would be a useful, easy way to combine all the unique values of a group into one string Example: ABC ABC DEF -> ABC DEF

Both options are now available in version 3.6.

1 Like