Forum Discussion
Resolver III"Many-to-Many" Error when mapping relationship between tables
Hi DataZoe . Thank you for your suggestions. I worked through all the steps listed in Query Settings. I found the relationship acutally worked up until the step of "Unpivot Other Columns." I redid this step using "Unpivot only selected columns"... for whatever reasons (which is quite beyond me)... the relationship now works. If someone else gets a similar problem... I'm not quite sure if this solution will be repeatable. Anyhow. There it was. Thanks for your suggestions though, I've made a mental note in case this happens to me again.
Cheers! Michelle
Microsoft Employeemichellepace Building on what Greg_Deckler has said, while they are numeric they are coming in as a text format. You can change this in the "Transform Data" and on the column header change them to a whole number data type:
With them both numeric, you can try the relationship again. Also, I sometimes get this error when there are blanks, so remove empty doesn't hurt if you aren't expecting blanks!
Resolver IIIHi DataZoe . Thank you for your suggestions. I worked through all the steps listed in Query Settings. I found the relationship acutally worked up until the step of "Unpivot Other Columns." I redid this step using "Unpivot only selected columns"... for whatever reasons (which is quite beyond me)... the relationship now works. If someone else gets a similar problem... I'm not quite sure if this solution will be repeatable. Anyhow. There it was. Thanks for your suggestions though, I've made a mental note in case this happens to me again.
Cheers! Michelle
- DataZoe
michellepace Wow that's interesting and good to know! Glad you got it working 🙂