Get started
Yandex DataLens

ALL_CONCAT

Written by

    Syntax

    ALL_CONCAT( expression [ , separator ] )

    Description

    Returns a string that contains all grouped values of expression delimited by separator (if separator is not specified, a comma is used).

    Argument types:

    • expression — Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID
    • separator — String

    Return type: String

    Note

    Only constant values are accepted for arguments (separator).

    Examples

    ALL_CONCAT([Profit])

    ALL_CONCAT([Profit], '; ')

    Data source support

    Materialized Dataset, ClickHouse 1.1, PostgreSQL 9.3.