catUniqueLimitAsc(value,delim,limit)¶
Definition¶
String catUniqueLimitAsc(Object value, String delim, Integer limit)
Description¶
Concatenates non-null values to a single string using delim. Will skip dulicate values stop concatenating after limit is reached. Values are stored in ascending order
Parameter Definition¶
| Name | Type | Description |
|---|---|---|
| value | Object | column to concatenate |
| delim | String | delimiter |
| limit | Integer | limit, negative number means no limit |