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