Reply
New Member
Posts: 1
Registered: ‎02-11-2017

Lab 1 Exercise 3 Error Msg as "Canada has duplicate values" and relationships between table

Hi, Can someone help me:

I was working on the exercise 3 and trying to apply the query per the instructions.   Then an error msg popped out saying:  "Canada in Country Population table  has duplicate values..."  so I went to the relationship panel to delete all the relationships that Country Name in County Population table has with other tables.   here is the screen shot of the relationships between tables

 

  1. Are the relationships in the screen shot corret?
  2. if not, how can I corret the relatioships?  For correcting relationships, I need detailed guidences because I dont know how to do that...yet

Thank yo so much !    BRs Anita

Capture.PNG

Regular Visitor
Posts: 43
Registered: ‎03-10-2016

Re: Lab 1 Exercise 3 Error Msg as "Canada has duplicate values" and relationships between

The relationships are right. I'm finish exercise3, it is worked for me, I don't know how to solve your issue according your description. Could you provide step3(3,4 sub-steps) screenshot?  Besides, please verify that you use Unpivot Other Columns not Unpivot Columns.