612314_en-US

liliconcom

Re: Supprimer les doublons

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: Remove duplicates

I am looking to in the same column, remove all duplicates but keep exactly 1 time the value corresponding to all duplicates.

 

Thanks anyway !

Re: Supprimer les doublons

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

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,

 

Remove Duplicates

How to remove duplicates (same values) in the same column? 

Quality and Process Engineering