Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hierarchical Relationships

Hi folks ,   I have a big hierarchy which is working fine .The hierarchy tables are linked like this hierarchy_1[nodeID]  1----->* hierarchy_2[parentID].     My problem is whenever I have a tabl...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

I'm a little confused about your description,

Since you want to link casefiles with all hierarchy tables, you could just create a relationship with hierarchy_7 table, what is your expected output?

 

Best Regards,

Lin

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Imagine this tables :

 

casefiles

 

nodeID          NumberCases

1                           2

2                           3

3                           1

4                           1

5                           5

 

hierarchy_7

nodeID              parentID

4                             10

3                              9

 

hierarchy_6

nodeID              parentID

9                             11

10                           12

5                             13

 

If I only link the hierarchy_7 with casefiles I will only get the values from the nodes 3 and 4 , and I still wanted the values from the hierarchy_6 from the node 5 ...

 

 

I hope this helps you visualize it :) v-lili6-msft 

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    Your data model is strange, I'm afraid it is difficult to create the relationship with all the hierarchy tables.

    Usually, the lowest level table should have the complete substructure.

    For your data model, It likes that use merge left join all the hierarchy tables then create the relationship with each column. It could not achieve.

    So I suggest you optimize this data model.

     

    Best Regards,

    Lin