Deleting rows with duplicate values in two columns?
Aug 19, 2024 01:55 PM(470 views)
Hello,
I need to delete multiple rows from my data table that have duplicate values in two columns I specify while preserving the first instance of the row. In the example below, only the third row would be deleted, as both columns are duplicates of row 1. Since the C rows have different results they would not be deleted, even though the entry is duplicated within the column.
ID
Result
A
X
B
Y
A
X
C
Z
D
Z
C
X
Conversely, it would work to copy all rows that have a unique combination in those two rows into a different location.
The most efficient solution, such as a JMP script, would be preferred as my data table is a couple of thousand rows tall, and I would really prefer not to do this by hand. Let me know if I need to clarify anything. Thanks!