Supprimer les doublons

[#1]

Comment supprimer les doublons (mêmes valeurs) dans une même colonne ? 

[#2]

An easy ad hoc solution could be to right-click and press select matching cells and then hit delete. 

ChristianBille_1-1678877543036.png

Does that help?

cheers

Christian 

[#3]

Je cherche à dans une même colonne, supprimer tous les doublons mais garder exactement 1 fois la valeur correspondante à tous les doublons.

Merci quand même !

[#4]

You can do it using the row selection menu.

First, you find and select duplicates (see below).

Then, you simply delete the rows selected (same menu, Rows>Delete Rows)

FN_0-1678877956791.png
Be aware that you get different answers depending on the columns you are selecting (if none, JMP looks at all columns).

[#5]

Hi @hcarr01,

Another option could be to use the platform "Subset" available in the menu "Table".

Here is my example datatable before (with duplicate values):

Victor_G_2-1678888542596.png

Then using the platform "Subset", specifying that I want only one value for each levels/unique values of my column (using my selected column as a stratification), you end up with the result you want :

Victor_G_1-1678888326762.png

As you can see, there are many ways to do this in JMP ;)

I hope this will help you,