Creating Hierarchy in MDM

[Former Member]

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?

[former_member201266 · Accepted solution]

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

[Former Member · Accepted solution]

can u please specify how to select two columns at a time in console or else give clean description of the steps u stated earlier thanx a lot.

[Former Member · Accepted solution]

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.

[Former Member]

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.