cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
ChernoffTurtle7
ChernoffTurtle7
Level III

how to quickly remove duplicate records(rows)?

Sep 12, 2024 12:46 AM (638 views)

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 !

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User jthi
Super User
Solution

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

Sep 12, 2024 01:17 AM (623 views)  |  Posted in reply to message from ChernoffTurtle7 09-12-2024

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 jthi
Super User
Solution

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

Sep 12, 2024 01:17 AM (624 views)  |  Posted in reply to message from ChernoffTurtle7 09-12-2024

Select Duplicate rows

jthi_0-1726118184245.png

and delete selected rows

 

Select Rows in Data Tables (jmp.com)

-Jarmo
BHarris
BHarris
Level VI

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

Created: Sep 13, 2024 01:17 PM  |  Last Modified: Sep 13, 2024 10:19 AM (573 views)  |  Posted in reply to message from jthi 09-12-2024

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.