Skip to Content
avatar image
Former Member

How to automap the hierarchy value?

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





Destination Values











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,


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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 30, 2010 at 06:20 AM

    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.


    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 30, 2010 at 06:35 AM

    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.



    Add comment
    10|10000 characters needed characters exceeded