topic how to quickly remove duplicate records(rows)? in Discussions

how to quickly remove duplicate records(rows)?

ChernoffTurtle7 — Thu, 12 Sep 2024 04:46:57 GMT

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 !

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

jthi — Thu, 12 Sep 2024 05:17:17 GMT

Select Duplicate rows

and delete selected rows

Select Rows in Data Tables (jmp.com)

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

BHarris — Fri, 13 Sep 2024 17:19:16 GMT

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.