Pigment AI Agents are here! Starting today, we’re launching new AI Agents and updating our documentation for them. Some pages may look different or redirect to new resources. Send us feedback through "Was this article helpful?" at the foot of the page

& function

  • Updated on Aug 22, 2025
  • 1 minute(s) read
Prev Next

Description

Concatenates all the given text arguments.

Syntax

text1 & text2 & ...

  • Each argument should have text type, using TEXT if needed

  • If Metrics are used, they should be at least on the Dimensions of the target Metric

Return type

Text

Examples

Case

Results

Return Type

"abc" & " - " & "123"

"abc - 123"

Text

Building a new list Property from existing ones: Country.Name & "(" & Country.Region & ")"

"France (Europe)"

Text

Excel equivalent: CONCAT(text1, [text2], ...)

Related articles