Forum Discussion
Create Relationship between Multiple tables.
I want to join three tables two of them are data tables and one is mapping table for one column category and subcategory.
Data Table 1 - Col1 Mapping table Data Table 2
Col1 Col 2 Col1
a1 a1 A A
b1 b1 B B
c1 c1 C
a2 a2 A
b2 b2 B
c2 c2 C
I was able to link Data Table 1 and mapping table but I can't like Data Table 2 to data table 1 or mapping.
2 Replies
What error do you get when you try to link data table 2 to the other tables?
If you delete the relationship between data table 1 and the mapping table, can you then make relationships with data table 2?
How was the mapping table created? Importing from an outside data source or calculated from data tables 1&2?Are there other tables in the model with any relationships to these tables that you haven't mentioned?
Error: It will create ambiguity between another mapping_table2 and Data_table1.
All the sources are excel files. But these files are coming from external sources which I am trying to link.
I have to link files using Area codes and sub-Categories. One mapping table is for summarizing Area Codes into internal roll up areas and other mapping table is for rolling up subcategories to internal categories. So mappiing table 1 is for categories and mapping table 2 is for area codes. Mapping was created by using the existing tables.
