cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • See how to interactively organize and restructure data for analysis. Register for May 29 webinar, 2pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-798124%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3Ecomment%20supprimer%20rapidement%20les%20enregistrements%20(lignes)%20en%20double%26nbsp%3B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798124%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJ'utilise%20g%C3%A9n%C3%A9ralement%20EXCEL%20pour%20supprimer%20les%20enregistrements%20(lignes)%20en%20double.%20C'est%20tr%C3%A8s%20simple%20dans%20Excel%20(Donn%C3%A9es-%26gt%3BSupprimer%20les%20doublons-%26gt%3BS%C3%A9lectionner%20toutes%20les%20colonnes).%20Je%20me%20demande%20comment%20ex%C3%A9cuter%20cette%20fonction%20dans%20JMP.%20Merci%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-798124%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EExploration%20et%20visualisation%20des%20donn%C3%A9es%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798144%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20comment%20supprimer%20rapidement%20les%20enregistrements%20(lignes)%20en%20double%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798144%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ES%C3%A9lectionner%20les%20lignes%20en%20double%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1726118184245.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1726118184245.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1726118184245.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68168i3931EA1FE2F1E607%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1726118184245.png%22%20alt%3D%22jthi_0-1726118184245.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eet%20supprimer%20les%20lignes%20s%C3%A9lectionn%C3%A9es%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.0%2F%23page%2Fjmp%2Fselect-rows-in-data-tables.shtml%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ES%C3%A9lectionner%20des%20lignes%20dans%20les%20tables%20de%20donn%C3%A9es%20(jmp.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798714%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20comment%20supprimer%20rapidement%20les%20enregistrements%20(lignes)%20en%20double%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798714%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ERemarque%20importante%20provenant%20du%20lien%20fourni%20par%20Jarmo%26nbsp%3B%3A%20si%20vous%20avez%20s%C3%A9lectionn%C3%A9%20des%20colonnes%2C%20JMP%20ne%20prend%20en%20compte%20que%20ces%20colonnes%20lors%20de%20la%20recherche%20de%20lignes%20en%20double.%20Ce%20n'est%20que%20si%20aucune%20colonne%20n'est%20s%C3%A9lectionn%C3%A9e%20qu'il%20examine%20la%20ligne%20enti%C3%A8re.%20Il%20s'agit%20en%20fait%20d'une%20fonctionnalit%C3%A9%20fantastique%20de%20JMP%20que%20davantage%20de%20personnes%20devraient%20probablement%20conna%C3%AEtre.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
ChernoffTurtle7
Level III

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

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

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

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

Select Duplicate rows

jthi_0-1726118184245.png

and delete selected rows

 

Select Rows in Data Tables (jmp.com)

-Jarmo
BHarris
Level VII

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.

Recommended Articles