CONCATENATE

CONCATENATE (not to be confused with CONCAT) appends strings together.

Function category: Text

Syntax

CONCATENATE(arg1, [arg2...])

CONCATENATE can take an arbitrary number of additional arguments.

Arguments

Description

arg1

A string.

arg2

Optional. Same as arg1.

Examples

Let's say we're given a response with the following vehicle information.

{
"data": {
"vehicles": {
"vehicle_1": {
"make": "Toyota",
"vin": "A31z056"
}
}
}
}

Example 1: Combine two strings into a single string

If we wanted to concatenate (combine) the values of "make" and "vin" into a single string, use the following function.

# Combine make and vin into a single string
CONCATENATE(data.vehicle_1.make, "-", data.vehicle_1.vin)
# Returns "Toyota-A31z056"

Example 2: Combine the elements of an array into a single string

If we wanted to concatenate the elements of an array into a single string, use the following function.

# Combine an array of strings into a single string
CONCATENATE({"a","a","a","a"})
# Returns "aaaa"