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
Example Formula | Output |
CONCAT(Campaign, " , " , Campaign Code) |
Summer Sale , SS01 |
CONCAT('Browser: ', Browser, ' Version: ', Browser Version) |
Browser: Edge Version: 85.0.564.44 |