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
- expression1: the first expression to be combined. The expression can be a string, number, or column that contains string or numerical values.
- 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.