Answers.Body: <p>One possibility is to export the Relationship civireport (under Reports - Contact Reports) and then use the power of Excel to analyze it, e.g. pivot on contact_a and relationship-a-b and have it sort by count descending, then anything with 2 or more is a duplicate.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-05T16:00:50.483Z
Answers.Text: yep, there doesnt seem to be a way within CiviCRM to tackle this issue, so using excell or something is required
Answers.UserDisplayName: Jonb
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-05T19:28:36.517Z
Answers.Text: if you are on Drupal you could build a view, aggregate, would then show all those with multiple relationships. in WP you could try the new Views equivalent. but neither of those will actually delete the relationship, so ideally i think you would be doing this direct in mysql and remove the duplicated relationships in the same task
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-03-25T17:33:11.170Z
Answers.LastActivityDate: 2019-03-25T17:33:11.170Z
Answers.UserDisplayName: Demerit
Body: <p>We have a data import error where a large number of individuals have two partners, instead of just the one they should have. This causes errors with another system we use that is linked to civicrm. I need to delete the duplicate relationships. Thanks for your help!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-25T23:37:40.740Z
Comments.Text: unclear if you mean there are duplicate partners - or duplicate relationships to a single partner. if the former you need to merge Contacts.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-05T16:00:04.230Z
Comments.Text: duplicate relationships to a single partner, so a merge does not appear to work
Comments.UserDisplayName: Jonb
Tags: <relationships><duplicate-contacts>
Title: How to search for individuals with duplicate partners
ThreadText: # How to search for individuals with duplicate partners
  
  (Asked by: username_0 on 2019-03-25)
  
  We have a data import error where a large number of individuals have two partners, instead of just the one they should have. This causes errors with another system we use that is linked to civicrm. I need to delete the duplicate relationships. Thanks for your help!
  
  **Tags:** relationships, duplicate-contacts
  
  > **Comments:**
  > **username_1**: unclear if you mean there are duplicate partners - or duplicate relationships to a single partner. if the former you need to merge Contacts.  
  > **username_0**: duplicate relationships to a single partner, so a merge does not appear to work  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-03-25. Score: 2 | Accepted answer
  
  One possibility is to export the Relationship civireport (under Reports - Contact Reports) and then use the power of Excel to analyze it, e.g. pivot on contact\_a and relationship-a-b and have it sort by count descending, then anything with 2 or more is a duplicate.
  
  > **Comments:**
  > **username_0**: yep, there doesnt seem to be a way within CiviCRM to tackle this issue, so using excell or something is required  
  > **username_1**: if you are on Drupal you could build a view, aggregate, would then show all those with multiple relationships. in WP you could try the new Views equivalent. but neither of those will actually delete the relationship, so ideally i think you would be doing this direct in mysql and remove the duplicated relationships in the same task  
  
  ---
  
  