concat ( [ distinct ] expression [, delimiter [, sort-weight]] )
returns the aggregated string concatenation of all values of expression
iterated over a number of records as defined by a group by
clause. Each value may be separated by the string found in delimiter.
The order of concatenation may be determined by sort-weight.
Sort-weight should return a numeric value where the lowest value
will render the item to be sorted first. If the word distinct occurs
before the expression, all duplicates will be disregarded.
Example:
Load Department, concat(Name,';') as NameList
from abc.csv group by Department;
EG:
Department, Name
1,A
1,B
2,C
2,D
Results
Department,NameList
1, A;B
2, C;D
