Deleting rows with duplicate values in two columns?

Mcc99 — Mon, 19 Aug 2024 17:55:04 GMT

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!

Re: Deleting rows with duplicate values in two columns?

jthi — Mon, 19 Aug 2024 18:02:20 GMT

Select your columns, Select Duplicate Rows, Delete Rows

JMP is able to write a script for that action to enhanced log / workflow

dt << Select Duplicate Rows(Match(:ID, :Result)) << Delete Rows;

Re: Deleting rows with duplicate values in two columns?

Mcc99 — Mon, 19 Aug 2024 18:26:40 GMT

Oh, that's super easy thanks!

topic Re: Deleting rows with duplicate values in two columns? in Discussions

Deleting rows with duplicate values in two columns?

Re: Deleting rows with duplicate values in two columns?

Re: Deleting rows with duplicate values in two columns?