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

[TammyPowlas]

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:

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

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?