Concatenate and Unique Concatenate


The Concatenate measure appends all values in the subset into a string.

The Unique Concatenate measure appends all unique values in the subset into a string. This means that each value will only be included in the string once.

Example:

Column A

Column B

Column C

1

1

1

1

 

3

1

3

3

With the columns from the table above, the following result would be given:

Column

Concatenate

Unique Concatenate

A

1, 1, 1

1

B

1, 3

1, 3

C

1, 3, 3

1, 3

See also:

Aggregations Overview