i hope somebody can help. I've got a data set of about 50000 rows and 2 columns (att1, att2). I wanna remove duplicates in which (and only if) the value of att1(row1) is equal to value of att2(row2) and value off att2(row1) is equal to att1(row2).
row1 100 200
row2 200 100
Sow row2 will be eliminated. Anybody an idea/solution?
Thanks so much!