Reply
New Member
Posts: 1
Registered: ‎03-16-2017

Lab1 Excercise 3: Duplicate Column

I have created the query for exercise 3 and applied all the changes that are listing. As I try loading the data, I get the following error.

 

Column 'Country Name' in table 'Country Population' contains a deplicate value 'Canada' and this is not allowed for columns on the one side of many-to-one relationship or for columns that are used as the  primary key of the table.

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

Re: Lab1 Excercise 3: Duplicate Column

I finish the exercise, Please confirm that you use Unpivot Other Columns option