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)

The following are the given field values.

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

For these field values, 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