Skip to Content

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:

/wp-content/uploads/2013/08/1sampledata_258969.jpg

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:

http://office.microsoft.com/en-us/excel-help/split-names-by-using-the-convert-text-to-columns-wizard-HA010102340.aspx#BMdelimit

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.

/wp-content/uploads/2013/08/2split_258970.jpg

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

/wp-content/uploads/2013/08/3rename_258998.jpg

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

/wp-content/uploads/2013/08/4finalresults_258999.jpg

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?

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply