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,
 
Concatenation options in SAP Lumira Discovery - 1
 

2. Using the ‘+’ Operator

Another method is to use the ‘+’ operator in the formula bar available under “Create Calculation”
 
string concatenation in SAP Lumira discovery - 1
 

3. The Context Menu

From the DataView, you can Ctrl+Select multiple columns and perform a concatenate operation
 
Concatenation options in SAP Lumira Discovery - 3
 
Interested to learn how to leverage SAP Lumira for your enterprise (or) train your business users in SAP Lumira Discovery? Reach out to us today.

 

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com