Remove Duplicates

[#1]

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

[#2]

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

Does that help?

cheers

Christian 

[#3]

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

Thanks anyway !

[#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)


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

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,