Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

Prompted by Get Your Data Geek Badges Today! by anita.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?

Labels in this area