Forum Discussion
Many to relation error
How to solve below error ''Column 'jntkey' in Table 'vw_pmsjntd_summ' contains a duplicate value 'EP-146 048 MW065' and this is not allowed for columns on the one side of a many-to-one relationship ...
vanessafvg
Community Champion
Community Championshemajuc you need to have a one to many relationship, obviously this is a many to many, so you either need to create a unique set of ids in a separte table and then link these 2 tables to the unique set of id's
i make it
then data not getting correct.....
- vanessafvg
shemajuc did you remove duplicates in power query?
2 issues could be happening here
1. if you have any blank id's this will create an issue, you should replace all blanks with a dummy id like -1 or something
2. power query is case sensitive, so if you removed duplicates in power query but the key has different cases like BM1 or bm1 power query will see this as different, make sure you change all to either upper or lower case
yes i did...
- vanessafvg
shemajuc yes you did what?