Hierarchy Load

[Former Member]

Hello,

I Need to load hierarchy in MDM but stuck in between..

My data format is like :- ( All Columns)

Code1 Desc1 Code2 Desc2 Code3 Desc3 Code4 Desc4 Code5 Desc 5

01 Food 01 Grocery 01 NNN 10 NN_ML 05 NN_ML_284

01 Food 01 Grocery 01 NN3 10 NN39_ML 05 NN_ML_287

02 GM 08 B Prod 34 Day 04 Day 10 M Day

02 GM 08 B Prod 34 X Mas 04 Promotion 10 Promotion

Name and Code are the fields in MDM in which data to be loaded.

Please suggest...

Regards

Himanshu

[Former Member]

thnks

[Former Member]

More Clear Way!

Code1 | Desc1 | Code2 | Desc2 | Code3 | Desc3 | Code 4 | Desc4 | Code5 | Desc5

01 | Food | 01 | Groce | 01 | NNN | 10 | NN_ML | 05 | NN_ML_284

01 | Food | 01 | Groc | 01 | NN3 | 10 | NN39_ML | 05 | NN_ML_287

02 | GM | 08 | Beauty | 34 | X Mas | 04 | Promotion | 10 | Promotion

please suggest!!

Rgds

Himanshu

[former_member189669]

Hi Himanshu,

Can you please elaborate on Hierarchy Structure ?

Alternately, suggesting a good read (link below) explaining heirarchy import scenario . You can adopt similar steps for your import.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/903c9530-52be-2a10-7d97-a48dc8082905&override...

Regards,

Vinay M.S

[Former Member]

Hello,

Thanks for response...

I had idea for the steps shown in the document.

Problem is with the current format. Let say in more simple words

Code1 Desc1 Code2 Desc2 Code3 Desc3

01 XY 02 YYZ 03 DEL

01 XY 03 GHK 05 DXB

02 NN 04 HGH 06 HNJ

02 NN 89 YTY 90 JUJ

My question is how with this format we can load.. we have let say 3 levels and codes goven ion front of it.

Rgds

Himanshu

[Former Member]

Hello Himanshu

In your simple i see two branch

one started from

01 XY

and second started from

02 NN

in Import manager

go to "Partition/Fields Value" tab

select Code1 in Source Partitions->Avialable fileds

Add it to Partition by

then

Seclect Desc1 and add it to Partition by

if you want create complex field - select all(Code1 and Desc1) in Partition by window and do right Click

in popup menu you can select "Combine" "Set combine delimeter"

then create next level

at the same as previous

Then go to "MAP Field/values" Tab

Select Code1[Partition]- filed in "Field mapping" window

map it to hierarchy field

Regards

Kanstantsin