cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
timothy_forsyth
Level III

Duplicate Rows

I have a table in in JMP 16.0 that has duplicate rows with respect to one of the columns.  I would like to retain the first row and delete all the following rows. For example from Table 1 to Table 2.

 

Table 1

 

timothy_forsyth_0-1707763090894.png

 

 

Table 2

timothy_forsyth_1-1707763154841.png

 

Drink deep, or taste not the Pierian spring
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Duplicate Rows

There are many options of doing this. One which might work in this case is to use Select Duplicate Rows

jthi_0-1707764301112.png

Select your column you wish to use for "unique" selection and go to that selection, select rows and delete extra rows

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Duplicate Rows

There are many options of doing this. One which might work in this case is to use Select Duplicate Rows

jthi_0-1707764301112.png

Select your column you wish to use for "unique" selection and go to that selection, select rows and delete extra rows

-Jarmo