I have an unbalanced n level hierachy of part numbers (see below)
I want to agregate all sales of a part to it's most recent part number, and I want a tree view of a part and it;s ancestors.
What should my script look like? I'm assuming that [Part] will be the parent, not sure what to make the node name. Part:Ancestor is a 1:n relationship.
Thanks for your help
M.
| Ancestor | Part |
| 000 | RAK5043 |
| 0.0125 | 1267652 |
| 0.0126 | 1267652 |
| 0.0191 | 1288674 |
| 1.0166 | 1276844 |
| 1.1705 | 1288681 |
| 1.1706 | 1288683 |
| 1.3018 | FBU7202 |
| 1.4054 | 1208092 |
| 1.6357 | 1246879 |
| 1.8044 | 1262964 |
| 002 | DW03625001 |
| 2.0970 | 1208091 |
| 2.0971 | 0069508 |
| 2.1072 | 0698039 |
| 2.1137 | FBU8909 |
| 2.1439 | 0068877 |
| 2.1440 | 0068877 |
| 2.2966 | 0068877 |
| 2.2967 | 0068877 |
| 2.2972 | 0068877 |
| 3 | 1321940 |
| 3.1537 | 0698037 |
| 4.0185 | 0698771 |
| 4.0397 | 0689687 |
| 4.0408 | 0698758 |
| 4.0582 | 0068705 |
| 4.0673 | 0068691 |
| 4.0843 | 0068692 |
