Contents x
    Concat
    • 16 Apr 2024
    • 1 Minute to read
    • Dark
      Light
    Contents

    Concat

    • Updated on 16 Apr 2024
    • 1 Minute to read
    • Dark
      Light
    Article summary

    General

    The Concat function can be used to concatenate a series of values using a separator.

    Example: You can use the Concat function to concatenate all values of a Datasource field with a separator such as a colon.

    Syntax
    The syntax of the Concat function is:

    Concat Function Syntax

    Concat(<separator>, <value_list>)

    Examples

    The following Expression returns a String that contains all values of the field SalesRepName of a Datasource named Consumer Sales separated by a comma and a whitespace:

    Concat Function Example

    Concat(", ", [Datasource].[Consumer Sales].[Field].[SalesRepName])

    The following example does the same but puts every value into a line of its own:

    Concat Function Example

    Concat(NewLine(), [Datasource].[Consumer Sales].[Field].[SalesRepName])

    Was this article helpful?
    What's Next