Returns text that is the concatenation of two or more fields or expressions.
Sample usage
CONCAT(Campaign, " , " , Campaign Code)
Syntax
CONCAT(X, Y [,Z, ...])
Parameters
X- literal text, a field, or an expression containing at least one field.Y- literal text, a field ,or an expression containing at least one field.Z- literal text, a field, or an expression containing at least one field.
Notes
- Aggregated fields cannot be used as parameters.
Examples
In the following examples, note that you can use either single quotes or double quotes, but they must be used consistently.
| Example formula | Output |
|---|---|
CONCAT(Campaign, " , " , Campaign Code) |
Summer Sale , SS01 |
CONCAT('Browser: ', Browser, ' OS Version: ', OS version) |
Browser: Edge Version: 85.0.564.44 |