on 05-26-2011 11:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.