cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
ChernoffTurtle7
Level III

how to quickly remove duplicate records(rows)?

I usually reach out to EXCEL for removing duplicate records(rows). Very simple in excel (Data->Remove Duplicates->select all columns). I am wondering how to perform this function in JMP. Thanks !

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: how to quickly remove duplicate records(rows)?

Select Duplicate rows

jthi_0-1726118184245.png

and delete selected rows

 

Select Rows in Data Tables (jmp.com)

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: how to quickly remove duplicate records(rows)?

Select Duplicate rows

jthi_0-1726118184245.png

and delete selected rows

 

Select Rows in Data Tables (jmp.com)

-Jarmo
BHarris
Level VII

Re: how to quickly remove duplicate records(rows)?

Important note from the link Jarmo provided -- if you have columns selected, JMP only considers those columns when looking for duplicate rows.  Only if no columns are selected does it look at the whole row.  This is actually a fantastic feature of JMP that more people should probably know about.

Recommended Articles