String aggregation functions

Concat() is used to combine string values. The script function returns the aggregated string concatenation of all values of the expression iterated over a number of records as defined by a group by clause.

concat([ distinct ] expression [, delimiter [, sort-weight]])

FirstValue() returns the value that was loaded first from the records defined by the expression, sorted by a group by clause.

FirstValue (expression)

LastValue() returns the value that was loaded last from the records defined by the expression, sorted by a group by clause.

LastValue (expression)

MaxString() finds string values in the expression and returns the last text value sorted over a number of records, as defined by a group by clause.

MaxString(expression )

MaxString() finds string values in the expression and returns the first text value sorted over a number of records, as defined by a group by clause.

MinString(expression )

Concat() is used to combine string values. The function returns the aggregated string concatenation of all the values of the expression evaluated over each dimension.

concat({[SetExpression] [DISTINCT] [TOTAL [<fld{, fld}>]] string[, delimiter[, sort_weight]])

MaxString() finds string values in the expression or field and returns the last text value in the text sort order.

maxstring({[SetExpression] [TOTAL [<fld{, fld}>]]} expr)

MinString() finds string values in the expression or field and returns the first text value in the text sort order.

minstring({[SetExpression] [TOTAL [<fld {, fld}>]]} expr)