Forum Discussion
Multiple Many-to-Many Relationship
I have tried using a Year table of distinct Year values and a Location table of distinct Location values and relate these to both of my tables, but alas it said it would create ambinguity. I can only get it to work with one or the other.
I will play with USERELATIONSHIP and see if this works.
I actually did come up with a workaround though... I concatenated Year and Location in both tables and this allowed me to create a one to many relationship. The visualization now filters for both location and year. For my purposes this works so I will probably just run with it.
Merging in Total Score to Table 2 was something I was considered, and perhaps it's more elegant than the one I listed.
Either way, thank you for your response.
You should be able to creae a Year table of distinct Year values and a Location table of distinct Location values and relate these to both of your tables. You may have to use the USERELATIONSHIP function for some calculations if you do it this way. You might also consider just doing a join in "M" to merge in your Total Score. Yes it would be repeated but you could always use something like MAX to get a "single" value.
I have tried using a Year table of distinct Year values and a Location table of distinct Location values and relate these to both of my tables, but alas it said it would create ambinguity. I can only get it to work with one or the other.
I will play with USERELATIONSHIP and see if this works.
I actually did come up with a workaround though... I concatenated Year and Location in both tables and this allowed me to create a one to many relationship. The visualization now filters for both location and year. For my purposes this works so I will probably just run with it.
Merging in Total Score to Table 2 was something I was considered, and perhaps it's more elegant than the one I listed.
Either way, thank you for your response.