Inherit Recursive Rollup of Subordinate Attributes

[KNguyen]

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

Org1	Org2
A	B
C	B
B	D
F	D

Table 2

Org	State
A	California
C	Texas
B	New York
F	Washington
D	Oregon

End Result

Org	State
A	California
B	California
B	Texas
B	New York
C	Texas
D	Oregon
D	California
D	Texas
D	New York
D	Washington

THanks 

[danilang · Accepted solution]

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