cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Split -- help needed

former_member283645
Participant
0 Kudos

Hi all,

I have a requirement where i get data from an Excel sheet which i need to import in to MDM.

But, the Excel format is slightly different.. like

the A column is completly filled with Field names..

And column B is filled with Values.. and continues c,d ef.. till how many ever records it consists of..

For Ex: here i have an excel with 2 article details.. i can have many, but the format is the same..

Article Code 4234124 34782349

Vendor/Supplier name agilent microsoft

Brand name agilent life cam microsoft cam

Article/Product Description life cam studio cam

Colour Blue red

Supplier Home Delivered line (SHD)? No yes

can anyone have an idea how i can convert this excel data and map them in Import manager???

please help

Kind Regards

Eva

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Eva - plz dont expect MDM to do this ! ; )

well u can do this in excel - all u need to invert rows and columns to solve ur problem !

Select the range you wish to 'invert' and copy.

Then Edit > Paste Specialand select the Transpose radio button in a new sheet !

now i can call myself a Excel expert as well !

thanks

-Adrivit

former_member283645
Participant
0 Kudos

Thanks for the Responses.

Cant this be done in import manager!!! Like via Pivot,split etc options that you see when you right click the fields in the source list in IM..

I tried but not sure whether using them in a right way.. can anyone help me out, as the customer does not wish to change the template and we get every 30 mins one excel for upload, so this is something which should be handled within MDM ..

Can anyone throw some Light to this issue..

Kind Regards

Eva

Former Member
0 Kudos

Hello Eva

You can do it in Import Manager but :

as guys adviced you - better way to did it in Excel

if you want to do it in Import Manager

You can use combination with clone fields + pivot + transformation

It is possible.... but easy and more faster to do it in Excel

Regards

Kanstantsin Chernichenka

former_member205403
Active Contributor
0 Kudos

Hi Kanstantsin,

Please can you explain your solution in detail and how Eva's requirement can be acheived by just using MDM import Manager..

Thank you..

Eva,

As you mentioned, you are getting file every 30 mins. I feel, instead of doing manual conversion you should design an automatic interface for this. If you have PI in your landscape then you can achieve it. Not sure about other middleware systems.

Best Regards,

Shiv

Former Member
0 Kudos

this is a classic example of how to kill a mosquito :

1. smack ! - mosquito dead !!!

OR

2. inject poison in ur blood - so that when the mosquito bites you - he's dead

Former Member
0 Kudos

Hello

we have:

Article Code 4234124 34782349

Vendor/Supplier name agilent microsoft

Brand name agilent life cam microsoft cam

Article/Product Description life cam studio cam

Colour Blue red

Supplier Home Delivered line (SHD)? No yes

your target:

Article Code Vendor/Supplier name Brand name Article/Product Description Colour Supplier Home Delivered line

4234124 agilent agilent life cam life cam Blue No

34782349 microsoft microsoft cam studio cam red yes

Do pivoting

Import manager guide (page 117)

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/72b8e7a42301bae10000000a42189b/content.htm

Than make map for your fields

Regards

Kanstantsin Chernichenka

former_member205403
Active Contributor
0 Kudos

Hi Kanstantsin,

Did you try this solution in the system?

Best Regards,

Shiv

Former Member
0 Kudos

pivoting can help make the data values (1 cwll in all rows - in this case) as field names (columns)

but how would you correspond the " original values" that are in the columns to rows ??

i doubt

thanks

-Adrivit

Answers (1)

Answers (1)

Former Member
0 Kudos

You may first convert rows to columns, columns to rows. Google for excel.

If you want to automate this, i heard this can be done by unix. I am afraid i dont know how.