cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
How can I find duplicate data using column header histograms or Rows menu?

JMP SE Wendy Tseng @wendytseng describes how to use the Distribution icons in column headers to screen your table for duplicate data. In her example, she uses the distribution icon row size/length in the column header to ID potential duplicates.

 

Alternately, she shows show to use the Rows Menu to select rows that contain duplicate value.  Simple select Rows > Row Selection > Select Duplicate Rows.  All duplicate rows except for the first are selected. If no columns are selected, duplicate rows are selected using all the columns. If columns are selected, duplicate values are found in the rows of those columns. The match is case sensitive.

 

Short and sweet!

 

 

 

gail_massari_0-1636055212510.png

 

Recommended Articles