Hi all,
I have a Relationship export that has two records representing each unique relationship (example: one record for Parent-Child and another for Child-Parent). I need to de-dupe this dataset so that each relationship only has 1 record. The RelationshipType and InverseRelationships are set up such that a given RelationshipType can have only 1 possible InverseRelationship, and vice versa. I've included an example of the dataset below:
| LegacyContactId | LegacyRelatedContactId | RelationshipType | InverseRelationship |
| 123 | 456 | Child | Parent |
| 456 | 123 | Parent | Child |
| 789 | 1011 | Business | Owner |
| 1011 | 789 | Owner | Business |
| 1213 | 1415 | Sibling | Sibling |
| 1415 | 1213 | Sibling | Sibling |
Note that for simplicity sake, I have put the relationship pair of records next to each other, but in the real dataset they may be far apart.
I thought that I could resolve this using a self-join with the Join tool, connecting Left: LegacyContact = Right: LegacyRelatedContactId and Left: LegacyRelatedContactId = Right: LegacyContactId, but that gives me the same number of records when I would have expected the count to decrease by half.
How would y'all suggest that I approach this? Thank you!
