Hi,
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?
Thanks in advance!
