Skip to Content
avatar image
Former Member

Creating Hierarchy in MDM

My source file is in the format -
<b>Parent</b>      <b>Child</b>
Valve         Belt
Belt           Conveyor

The expected hierarchy in MDM is -
<b>Valve</b>
   |_______<b>Belt</b>
                  |________<b>Conveyor</b>

How do we create this hierarchy from the flat source file?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2007 at 11:13 AM

    Hi Anoop,

    I work on this scenario; but currently i currently don't have the tools on this system to guide every step exactly.

    But i will give you the concept and general steps over there;

    Here the concept is about Self-Join; by this i mean referring data in the same table in different column.

    Steps:

    Select both the columns(parent and child) > right click > select 'Create Hierarchy filed' and select the parent and child fields.

    this will do it. But to the best of my knowlege the source table should be an Updateable table, like access; I know that it does not work with excel or XML. but for the sure it works with access and i dont know about text files. just try it out. the step are same; if you could not do it with .txt the access will work because it required on Updateable source. So all the best.

    Regards,

    CHARAN

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Tejas,

      The Taxonomy table is created in Console, however, creation of hierarchy within the Taxonomy is done through Import Manager. There is no need to create/select two columns in Console.

      You might be having a soure file containing the hiearachy and a destination Taxonomy in table in MDM with atleast one filed. (Created by default)

      Follow following steps:

      1. Open Import Manager by specifying the location of Source File. Your cource file should be a updatable data source (e.g. XML, Excel file is not a updatable souce - for more info on this see the Data Manager Reference Documentation).

      2. Select appropriate Source and Deatination from drop down box.

      3. In Source Hierarchy, Select both the columns(parent and child) > right click > select 'Create Hierarchy filed' and select the parent and child fields.

      4. Click on create. This will generate 2 new fields in the “Field Mapping Source Fields” containing the Hierarchy.

      5. Map the Source to Destination and complete other usual steps.

      Hope this helps. If you have any further difficulties, give the details of source file format.

      Regards,

      Anoop

      PS: Do give point if found helpful.

  • avatar image
    Former Member
    Aug 17, 2007 at 09:20 AM

    Hi Anoop,

    you want A->B->C. create a table valve of type lookup hierarchy,

    give field belt with lookup flat. again table belt have a field which points towards a field of lookup flat. and these fields should be display fields.

    it will help you a lot. if problem occurs let me know again.

    Regards,

    Alok

    please reward points if found problem solved.

    Add comment
    10|10000 characters needed characters exceeded