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 |
