Forum Discussion
My dynamic visual won't work (relations)
Hello,
I found my solution. I needed 2 things :- Create a bridging table to have unique type of accomodation keys to create a one to many relation.
- Make sure my city keys table was setted as well on one to many relation. I don't know why but it wasn't the case, so I recreated this file (file 2) and everything worked fine.
Thank you vanessafvg for your help
can you share a picture of your data model?
Absolutely vanessafvg :
File 1 on top. File 2 on the left. File 3 on the right. As you can see, file 3 can't be connected to file 1 (dotted relation). "Code INSEE" means "city key".
Here are what my files look like :
Thanks for your help
i have added in a bridging table
not sure if that is giving the desired result it might need some more work.
if it incorrect please provide an example of one test you can expect when correct
Thanks again for your time vanessafvg
It actually doesn't work : when I click a type on the top graphic, it doesn't change my bottom graphic.
But I think the solution of creating a "bridging table" is the one. I tried it on another project, but I created a "type of accomodation bridging table" instead of a city key one, and it seems to work.
The idea is :
File 1 is connected to file 2
File 3 is connected to file 2
File 1 is connected to file 3 but not directly, towards a file 4 "type of accomodation"
Exemple : New projectDo you confirm the method ?
Thanks !what did you click on and what did you expect to change? when i did it i thought it changed. ideally the whole thing needs to be remodelled in my opinion
before clicking
after cllicking