Reply
Frequent Visitor
Posts: 3
Registered: ‎02-11-2017
Accepted Solution

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


Accepted Solutions
Member
Posts: 93
Registered: ‎03-10-2016

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

The relationship is right.

View solution in original post


All Replies
Highlighted
Member
Posts: 93
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.

Frequent Visitor
Posts: 3
Registered: ‎02-11-2017

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

Hi, LeifGreen:  thank you so much for your reply.   do you mean the relationship in my screen shot is correct?  Yes, I used Unpivot Other Columns 

Member
Posts: 93
Registered: ‎03-10-2016

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

The relationship is right.

Frequent Visitor
Posts: 3
Registered: ‎02-11-2017

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

LeifGreen:  thank you so much!