Skip to Content

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:

/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?

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