Skip to main content
CONCAT DISTINCT

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

Updated over 2 weeks ago

Description

The CONCAT_DISTINCT() 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_DISTINCT(text)

Output

text

Variables

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

Example

CONCAT_DISTINCT(Tags) with Delimiter ', '

ID

Tags

CONCAT

1

Apple

Apple, Banana, Cherry

2

Banana

Apple, Banana, Cherry

3

Cherry

Apple, Banana, Cherry

4

Apple

Apple, Banana, Cherry

Did this answer your question?