# Concat - script function
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.
Syntax:
Concat (Concat ([ distinct ] string [, delimiter [, sort\_weight]][ distinct ] string [, delimiter [, sort\_weight]]))
Return data type: string
Arguments:
The expression or field containing the string to be processed.
Concat arguments
| Argument | Description |
| --- | --- |
| string | The expression or field containing the string to be processed. |
| delimiter | Each value may be separated by the string found in delimiter. |
| sort\_weight | The order of concatenation may be determined by the value of the dimension sort\_weight, if present, with the string corresponding to the lowest value appearing first in the concatenation. When 0 is used as the sort\_weight argument value, sorting is not applied to the output. If the sort\_weight argument is omitted, the function defaults to alphanumeric sorting. |
| distinct | If the word distinct
occurs before the expression, all duplicates are disregarded. |
Examples and results:
Add the example script to your document and run it. Then add, at least, the fields listed in the results column to a sheet in your document to see the result.
Examples and results
| Example | Result field | Result value |
| --- | --- | --- |
| `TeamData:
`
`LOAD * inline [`
`SalesGroup\|Team\|Date\|Amount
`
`East\|Gamma\|01/05/2013\|20000
`
`East\|Gamma\|02/05/2013\|20000
`
`West\|Zeta\|01/06/2013\|19000
`
`East\|Alpha\|01/07/2013\|25000
`
`East\|Delta\|01/08/2013\|14000
`
`West\|Epsilon\|01/09/2013\|17000
`
`West\|Eta\|01/10/2013\|14000
`
`East\|Beta\|01/11/2013\|20000
`
`West\|Theta\|01/12/2013\|23000
`
`] (delimiter is '\|');`
` `
`Concat1:`
`LOAD SalesGroup,Concat(Team) as TeamConcat1 Resident TeamData Group By SalesGroup;` | SalesGroup
East
West | TeamConcat1
AlphaBetaDeltaGammaGamma
EpsilonEtaThetaZeta |
| Given that the TeamData table is loaded as in the previous example:
`LOAD SalesGroup,Concat(distinct Team,'-') as TeamConcat2 Resident TeamData Group By SalesGroup;` | SalesGroup
East
West | TeamConcat2
Alpha-Beta-Delta-Gamma
Epsilon-Eta-Theta-Zeta |
| Given that the TeamData table is loaded as in the previous example. Because the argument for sort\_weight is added, the results are ordered by the value of the dimensionAmount:
`LOAD SalesGroup,Concat(distinct Team,'-',Amount) as TeamConcat2 Resident TeamData Group By SalesGroup;` | SalesGroup
East
West | TeamConcat2
Delta-Beta-Gamma-Alpha
Eta-Epsilon-Zeta-Theta |
| ```
T1:
Load *
INLINE [
EmployeeID, Unit, Department, Age, Salary, Country
1, A, z, 30, 81000, GER
2, B, z, 29, 39000, IRL
3, B, y, 40, 58000, IRL
4, A, y, 45, 71000, USA
5, A, z, 26, 79000, GBR
6, B, z, 20, 31000, GER
7, A, y, 56, 29000, USA
8, A, y, 35, 52000, GBR
];
T2:
Load
Unit,
Concat(Age, '-', 0) as ConcatNoSort
resident T1 group by Unit;
``` | Unit
A
B | ConcatNoSort
30-45-26-56-35
29-40-20 |