Skip to main content

CONCAT

Concatenates multiple text values into a single value

Updated this week

Description

The CONCAT() function allows you to combine multiple text strings into one, which can be useful for creating dynamic labels, combining names, or constructing sentences from text fragments.

Syntax

CONCAT(text1, text2, โ€ฆ) or

CONCAT(@list_variable)

Output

text

Variables

  1. text1, text2, ... : These are the text strings you want to concatenate. You can include multiple text strings separated by commas.

  2. list_variable: list variable; alternative text inputs.

Example 1

CONCAT(`Column 1`,`Column 2`,`Column 3`)

Column 1

Column 2

Column 3

CONCAT

Hello

,

world!

Hello,world!

This

is a

test

Thisis atest

Savant

is

amazing

Savantisamazing

Example 2

CONCAT('How ','are ','you','?')

Column 1

Column 2

Column 3

CONCAT

Hello

,

world!

How are you?

This

is a

test

How are you?

Savant

is

amazing

How are you?

Example 3

CONCAT(`Column 1`,'|Column 1')

Column 1

Column 2

Column 3

CONCAT

Hello

,

world!

Hello|Column 1

This

is a

test

This|Column 1

Savant

is

amazing

Savant|Column 1

Example 4

CONCAT(TO_TEXT(TODAY()),'_is_today.')

Column 1

Column 2

Column 3

CONCAT

Hello

,

world!

2023-10-11_is_today.

This

is a

test

2023-10-11_is_today.

Savant

is

amazing

2023-10-11_is_today.

Example 5

COALESCE(@list_variable)

List

CONCAT

("a", "b", "c")

"a, b, c"

Did this answer your question?