Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 -

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

Former Member
Former Member replied

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.


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.



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question