Skip to Content
Author's profile photo Tammy Powlas

Data Manipulation with Do-It Feature in Lumira – Get Your New Data Geek Badge

Prompted by Get Your Data Geek Badges Today! by Anitay Yuen I noticed this:

Mission 2: Share your Data Geek Knowledge – NEW

I thought why not share a feature I’ve used with various types of data.  See a simple Excel example below:


I would like to separate the Name field into First Name, Middle Initial, Last Name…perhaps to load this into SAP?

First, I Googled the steps and they work in Excel, but I needed step-by-step directions:

These work but will I remember them when I need them next month?

Using SAP BusinessObjects Lumira I didn’t have to search anything.  I simply opened the Data Manipulation tool after acquiring the data.


I select the Name column and select Split as shown above.


After I split the columns I simply rename the columns by double clicking on the column.


So now I have my desired First Name, Middle initial, and Last Name fields separated into columns. This was easy to use, not something I needed to look up and I’ll remember it next time I need to do it.  I also find with large numbers of fields and columns Lumira is helpful to use against Excel.

Related Links:

Big Data Manipulation? “Do-it” with SAP Lumira

Get Your Data Geek Badges Today!

So how will you share your knowledge to earn the second Data Geek badge?

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.