Menu
Amazon QuickSight
User Guide

concat Function

concat concatenates two or more strings.

Syntax

Copy
concat(expression, expression [, expression ...])

Arguments

concat takes two or more string expressions as arguments.

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

Return Type

String

Examples

The following example concatenates three string fields and adds appropriate spacing.

Copy
concat(salutation, ' ', first_name, ' ', last_name)

For the field values:

Copy
salutation first_name last_name ------------------------------------- Ms. Jane Doe Dr. Sally Roe Mr. John Smith

The following values are returned:

Copy
Ms. Jane Doe Dr. Sally Roe Mr. John Smith

The following example concatenates two string literals.

Copy
concat('Hello', 'world')

The following value is returned:

Copy
Helloworld