Amazon QuickSight – Concat

The CONCAT function in Amazon QuickSight combines two or more strings into one string.

Syntax

#Start#
concat(expression1, expression2 [, expression3 ...])
#End#

 This function takes one or more arguments

1. expression1: the first expression to be combined. The expression can be a string, number, or column that contains string or numerical values.
2. expression2: the second expression to be combined, and so on.

Example

#Start#
CONCAT("Hello, ", "world!")
#End#

This will combine the strings “Hello, ” and “world!” into the string “Hello, world!”.

The CONCAT function can be useful in data analysis and reporting when you need to combine two or more values into a single value. For example, you could use this function to combine the first name and last name of a customer into a single full name.