cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles