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?
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.