- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to quickly remove duplicate records(rows)?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to quickly remove duplicate records(rows)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: how to quickly remove duplicate records(rows)?
Created:
Sep 13, 2024 01:17 PM
| Last Modified: Sep 13, 2024 10:19 AM
(1034 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.