BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
rshehadah
Community Trekker

Delete Duplicate rows

Hi,

 

I have a datable that I want to delete rows on a duplicate value in a col. 

 

Thank you,

Rami

0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: Delete Duplicate rows

Select Duplicat Rows() function will highlight rows for a specified column(s)

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt <<
Select duplicate rows( Match( :name ) );
xx=dt<<get selected rows;
if(n rows(xx)>0,
	dt<<delete rows;	
);
Jim

Re: Delete Duplicate rows

Hi Rami,

 

Jim's script is a nice option, but if you have JMP 14 you can also select duplicate rows in a column by point and click.  

Highlight the column of interest, go to the Rows dropdown or red hot spot.  Rows > Row Selection > Select Duplicate Rows.  All of the duplicate values will be highlighted in by row number.  Right click anywhere in the blue region and select delete.  

 

HTH

Bill

3 REPLIES 3
txnelson
Super User

Re: Delete Duplicate rows

Select Duplicat Rows() function will highlight rows for a specified column(s)

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt <<
Select duplicate rows( Match( :name ) );
xx=dt<<get selected rows;
if(n rows(xx)>0,
	dt<<delete rows;	
);
Jim

Re: Delete Duplicate rows

Hi Rami,

 

Jim's script is a nice option, but if you have JMP 14 you can also select duplicate rows in a column by point and click.  

Highlight the column of interest, go to the Rows dropdown or red hot spot.  Rows > Row Selection > Select Duplicate Rows.  All of the duplicate values will be highlighted in by row number.  Right click anywhere in the blue region and select delete.  

 

HTH

Bill

lwx228
Community Trekker

Re: Delete Duplicate rows

It is recommended that JMP continue to improve to enable all automation with JSL.Thank you very much!

0 Kudos