Skip to content
Reference > Aggregate Methods

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