How to automap the hierarchy value?

[Former Member]

Hi Support,

Would please tell me how to modify the data format below and let them automap the destination hierarchy value?

Here is an example:

Source Values

#Capital

*Sweden

*Portugal

*Netherlands

Destination Values

#Capital

*Germany

-Berlin

*Italy

*France

-Paris

*Spain

-Madrid

*England

-London

I don't want to use the option "Add as Sibling" because the number of the source values are more than 10 thousands and it is a tough job to map them manually. So I want to use the automap feature to map the second level nod atomatically.

Thanks & Regards,

Song

Edited by: songxu on Mar 30, 2010 5:06 AM

[Former Member · Accepted solution]

Hi Songxu,

See, for using Auto-map feature it is effective only if you have all values in your hierarchy table as UNIQUE, If you have some values which are common across different nodes, then you should not go for auto-import because it would result in data discrepancies. As you will see some source values mapped twice to target values which should be avoided else will create duplicates.

I do understand that you have 10 thousands source values but doing manually result you in adding effective node under Target node rather than assigning wrong Target node using Auto-map feature because it can result in same source value mapped with more than one target nodes.

Other alternative, if this hierarchy values are not assigned to any table, i mean with main table records as of now. You can delete all these hierarchy values from MDM data Manager. After this now during import you don't need to bother about Add Sibling under correct Target node. You can directly go for option Add Branch as Child after selecting all the source values using keyboard option (Ctrl +A). This will import all your source structure to target Hierarchy table in one go.

Regards,

Mandeep Saini

[Former Member · Accepted solution]

Hi Mandeep，

Thanks for your quick reply.

I believe your second solution is what we want.

Thanks & Regards,

Song

[Former Member]

Hi Song

Steps for auto mapping are:

1. define the hierarchy table in console with Key mapping as Yes.

2. Import the records for the first time and map the unique keys for the hierarchy table with remote key available in destination items.

3. Check in data manager in record mode for the entries in Hierarchy table if remote keys have been updated using edit key mapping feature.

4. For next imports automapping will happen for the values.

BR-

Ravi

[Former Member]

Hi Ravi,

Thanks for the help.

I have solved the issue now.

Regards,

Song