Notification

This Help Center is moving to Cloud. Learn more.

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

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

Related resources

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
13854934571714286710
true
Search Help Center
true
true
true