Concatenate

The Concat function returns a string resulting from the concatenation of two or more input strings. In other words, two or more strings are combined as one continuous string. For example, concatenating the two strings "Micro" and "Strategy" would result in the single string "MicroStrategy".

Syntax

Concat(Argument1, Argument2, ... , ArgumentN)

Where:

• Argument1, ... , ArgumentN are facts, metrics, columns, or string values.

Example

The Concat function can help to create attribute forms that are a combination of multiple columns in database tables. For example, an LU_CUSTOMER table includes two columns: CUST_FIRST_NAME and CUST_LAST_NAME. You can create a single attribute form that combines these two columns as described below.

Concat([CUST_FIRST_NAME], [CUST_LAST_NAME])

The input from the first column is concatenated with the input from the second column, to display information such as JohnDoe and JaneDoe for the attribute form.

For scenarios such as the one described above, you can use the ConcatBlank function (see Concatenate with a Blank) to concatenate the strings and include a space between the two strings. This can result in attribute forms that are easier to read. For example, rather than displaying JohnDoe, the attribute form would display John Doe.

For an additional example of using the Concat function, refer to the example section for the function Initial Cap.