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 !
Data Exploration and VisualizationRe: how to quickly remove duplicate records(rows)?Select Duplicate rows
and delete selected rows
Select Rows in Data Tables (jmp.com)
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.
