I have a datatabel and script which is pretty straight forward:
Hierarchy(Material,HeadMaterial,MaterialName)
Load
Material,
HeadMaterial,
MaterialName
from Table1;
From this I created an hierarchy, no problem. But the challange here:
In every nod, the nod itself contains more nodes and the node is found in the Parent field, with no connection to the "original" parent. So this is the hierarchy I get (Notice material 3 is found both as node and as parent)
HeadMaterial
Submat 1
Submat 2
Submat 3
Submat 4
1
2
3
4
3
5
6
7
9
7
10
15
This is what I need, you see that HeadMaterial 3 an is found under HeadMaterial 1 but lacks the submaterials included. Same for material 7 but under material 3 instead. Note that material 3 and 7 can have diffrent parents with no restriction to how many.
HeadMaterial
Submat 1
Submat 2
Submat 3
Submat 4
Submat 5
Submat 6
Submat 7
1
2
3
4
5
6
7
9
10
15
Any suggestions on how the create an single hieracy including ALL submaterials?
