CONCAT

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 Input Output
CONCAT(Campaign, " , " , Campaign Code) Campaign : Summer Sale

Campaign Code : SS01

Summer Sale , SS01
CONCAT(Campaign, "|", Campaign Code) Campaign : Summer Sale

Campaign Code : SS01

Summer Sale|SS01

Related resources

Was this helpful?
How can we improve it?