nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to quickly remove duplicate records(rows)?

ChernoffTurtle7

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 !

Accepted answers

Select Duplicate rows

and delete selected rows

Select Rows in Data Tables (jmp.com)

All comments

Select Duplicate rows

and delete selected rows

Select Rows in Data Tables (jmp.com)

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.

Quick Links