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,

String Concatenation in SAP Lumira Discovery

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

3. The Context Menu

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

String Concatenation in SAP Lumira Discovery

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

Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!