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 indelimiter. 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 worddistinct occurs before the expression, all duplicates will be disregarded.
Load Department, concat(Name,’;’) as NameList from abc.csv group by Department;