Skip to main content
CONCAT

Combines unique text values from multiple rows in a specified field into a single text value

Updated over 2 weeks ago

Description

The CONCAT() function combines unique text values from multiple rows in a specified field into a single text value. It ensures that each string appears only once in the output.

Syntax

CONCAT(text)

Output

text

Variables

  1. text: the text field to be combined into a single text value.

Example

CONCAT(Tags) with Delimiter ', '

ID

Tags

CONCAT

1

Apple

Apple, Banana, Cherry, Apple

2

Banana

Apple, Banana, Cherry, Apple

3

Cherry

Apple, Banana, Cherry, Apple

4

Apple

Apple, Banana, Cherry, Apple

Did this answer your question?