Concat - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Concat

concat concatenates two or more strings.

Syntax

concat(expression1, expression2 [, expression3 ...])

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.

concat(salutation, ' ', firstName, ' ', lastName)

The following are the given field values.

salutation firstName lastName ------------------------------------------------------- Ms. Li Juan Dr. Ana Carolina Silva Mr. Nikhil Jayashankar

For these field values, the following values are returned.

Ms. Li Juan Dr. Ana Carolina Silva Mr. Nikhil Jayashankar

The following example concatenates two string literals.

concat('Hello', 'world')

The following value is returned.

Helloworld