Forum Discussion
How to relate these two Many to Many Tables
This absolutely should work. I often work with 6 lookup tables in my data set with several created in the same manner. I do keep a 'stock' date table and item table but most others are ad hoc.
I have worked with several issues along the same lines. These best answer I have found is to merge or append the tables together into one big table and build from there. It isn't difficult and, at least for me, has returned reliable results.
You can find merge and append in the query editor.
Hi Kcantor:
Thanks a lot for the reactivity and prompt answer.
I'm familiar with merge and append specially becuase I used both of them in PowerQuery sometimes. But in this case I think it is not the appropiate solution because Receptions table and Non-compliants table differ a lot each other.
It could possible to join, but most of the colums in Receptions table will be blank. Doing in the other way around, I would lose a lot of information needed for other graphs/visuals.
Thanks anyway!