Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Lab1 Excercise 3: Duplicate Column
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-16-2017 07:10 AM
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.
Highlighted
Re: Lab1 Excercise 3: Duplicate Column
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-16-2017 10:47 PM
I finish the exercise, Please confirm that you use Unpivot Other Columns option