This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Duplicate key value issue

Posted on 07-31-2021 03:57 PM
ravikiran
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I am seeing an error " Table ‘Customers’ has duplicate key value ‘’ in the key columns of rows 2 and 3." I only have one column identified as a key. Not sure why it thinks I have two columns as key. Please review the attached picture.

3X_a_2_a214bdc76002bba4d17f96f7b77828bfe61c57bc.png

0 2 180
Topic Labels
  • UX
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

It doesn’t think you have two columns as key. It is telling you that you have 2 records that have the same key value, specifically in row 2 and 3.

Posted on --/--/---- --:-- AM
ravikiran
Bronze 1
Bronze 1
In response to Marc_Dillon
Reply posted on --/--/---- --:-- AM

Oh. I didn’t realize it was related to the underlying data. Thank you!

Top Labels in this Space