Inherit Recursive Rollup of Subordinate Attributes

Question

Hi

How do i do a recursive roll up. If I have a file containing a relationship of two orgs and another file containing attribute of the org. Essentially, recursive roll up to build a hierarchy and the superior org inherit all the attributes of the subordinate?

Table 1

Org1Org2ABCBBDFD

Table 2

OrgStateACaliforniaCTexasBNew YorkFWashington  DOregon

End Result

OrgStateACaliforniaBCaliforniaBTexasBNew YorkCTexasDOregonDCaliforniaDTexasDNew YorkDWashington

THanks

danilang · Accepted Answer

hi @KNguyen

Check out the solutions to Weekly Challenge 81: Multi-level Bill of Materials Problem.  A bill of materials is equivalent to a company hierarchy, so one of the solutions there will get you started.

Dan