Forum Discussion
Best practice for Data Model
As there is one to many relationship between the tables , follow the below steps and try and update the model:
1 Merge all the Tables 1:6 in Mtable (merge using category)and only bring the associated sub category (only consider sub category column) while merging.
2. the above step will help you bring Category and Sub Category in Mtable
3. create a key for Category and sub category
4. As we have merged all the six tables there might be a many to many relation with those tables.
5. To overcome the many to many relationship create a bridge table with distinct values of Key (Category and Sub Category)Please update the ticket if you need any further clarification.
PC2790 , you need to share the full data model.
Becasue of the criticality of the data, I am not able to share the exact model.
Though I have tried to replicate the same as below:
Now, I want to filter the matrix using the Sub Category
This is where I am not getting the desired result.
As there is one to many relationship between the tables , follow the below steps and try and update the model:
1 Merge all the Tables 1:6 in Mtable (merge using category)and only bring the associated sub category (only consider sub category column) while merging.
2. the above step will help you bring Category and Sub Category in Mtable
3. create a key for Category and sub category
4. As we have merged all the six tables there might be a many to many relation with those tables.
5. To overcome the many to many relationship create a bridge table with distinct values of Key (Category and Sub Category)Please update the ticket if you need any further clarification.
Yes! That's the right way to do it.
Thanks a lot.
It worked