Forum Discussion
Hierarchical Relationships
Community Supporthi, 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
Casefiles has values in all tables of the hierarchy . My goal is to create a hierarchical tree map with values of casefiles , and if I only link the casefiles with the hierarchy_7 , on my tree map I will only get values from hierarchy_7 .
Appreciate your help v-lili6-msft
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
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