This is part of the SAP Lumira Discovery blog series.

String concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “snow” and “ball” is “snowball”. There are practical scenarios when we need to concatenate two columns. For example, we may want to concatenate customers’ first & last names in a report.

SAP Lumira Discovery supports various data formats for concatenation. For example, it can concatenate:

Two strings : <First Name> <Last Name>
Alpha Numeric : <State> <Zip Code>
Multiple strings : <$> <Sales> <M>

There are 3 different ways to achieve concatenations in SAP Lumira Discovery,

1. Using the Concatenate Function

Build a custom dimension using the “Concatenate” function available under “Create Calculation” or the formula icon as shown below,
 

2. Using the ‘+’ Operator

Another method is to use the ‘+’ operator in the formula bar available under “Create Calculation”

3. The Context Menu

From the DataView, you can Ctrl+Select multiple columns and perform a concatenate operation

Interested to learn how to leverage SAP Lumira for your enterprise. Write to us by clicking here.