Hey Did you find a way to get this done? I am also trying to create a hierarchy from 2 data sources. Can we create a hierarchy using a field from one data source to another field from another data source?
1 of 1 people found this helpful
I've been looking at this problem too.
I have a single table with all the parent-child relationships in it -- all the way from level 1 down to level N, i.e. Level 1 to 2, level 2 to 3 ... level N to N+1 etc etc. In the table there is the ID, the Parent ID and the Member name. The levels are uneven - some items go down to level 3, some to level 6 etc.
I ended up joining the table to itself N times (left join), using N.ID = N+1.ParentID. Then I filtered the first instance for only the top level. You can then alias the NULLs, or create calculated fields to bring in the parent name instead.
Anyone else tackled this problem before? How is it done with other technologies? Recursive SQL?
Would be interested to see what other options there are out there.