topic Re: Supprimer les doublons in Discussions

Supprimer les doublons

hcarr01 — Thu, 08 Jun 2023 16:28:37 GMT

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

Re: Supprimer les doublons

ChristianBille — Wed, 15 Mar 2023 10:52:50 GMT

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

Does that help?

cheers

Christian

Re: Supprimer les doublons

FN — Wed, 15 Mar 2023 11:04:26 GMT

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)

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

Re: Supprimer les doublons

hcarr01 — Wed, 15 Mar 2023 11:03:21 GMT

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 !

Re: Supprimer les doublons

Victor_G — Wed, 15 Mar 2023 13:56:44 GMT

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):

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 :

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

I hope this will help you,