Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel Split -- help needed

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

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question