Re: How to remove a row which contains a duplicate column entry?

["Emil M Friedman" <emilfrie@alumni.princeton.edu>]

That will replace all formulas with values.
-------------------------------------------
Emil M Friedman, PhD
2304 Richmond Road
Beachwood, OH  44122
emil.friedman@alum.mit.edu
emilfrie@alumni.princeton.edu
216-591-1750
http://www.statisticalconsulting.org
----- Original Message ----- 
From: "lauralinder" <laura.linder@kodak.com>
To: <jmp-l@lists.biostat.wustl.edu>
Sent: Thursday, May 12, 2005 2:00 PM
Subject: Re: [jmp-l] How to remove a row which contains a duplicate column 
entry?

> An easy way is to do a Tables Summary of the entire data table.
> Group on every single column in the data table.  This works if the
> rows are completely duplicated.  Delete the Nrows column and the
> summary table should be exactly what you want.
>
>
>
> Laura
>
>
> --- In jmp-l@yahoogroups.com, "James T Metz" <james.metz@a...> wrote:
> > JMP Users,
> >
> >         Can someone please help.
> >
> >         I am looking for a procedure, formula, or JSL script that
> will
> > either mark or remove a row from a data table for
> > which one of the columns contains more than one identical entries
> > (duplicates, triplicates, etc.) based on a particular
> > column e.g., "Compound ID".
> >
> >         For example, I have a data table.  One of my (character)
> columns
> > is named "Compound ID".  I have 3 rows out
> > of 25,000 rows which have the same identical Compound ID - "JTM-
> 00001A". I
> > also have other duplicates such as
> > 2 rows with Compound ID -"JTM-12345B", 2 rows with Compound ID -
> > "JTM-67895A" and so forth.  I want to generate
> > another table which contains single, unique Compound ID's i.e.,
> there are
> > no duplicate names.  You may also assume
> > that you can either mark or remove any of the duplicate or
> triplicate or
> > ... rows i.e., the information in the other columns
> > is the same.  I want to retain all of the rows which are not
> duplicates,
> > triplicates, etc.
> >
> >         Does anyone have any intelligent way to do this?  I can
> search for
> > (and remove) duplicates using the Histogram
> > platform (with character data), but this is very tedious and
> inefficient!
> >         I would be most grateful if someone could help.  Thank you!
> >
> >         Regards,
> >         Jim Metz
> >
> >
> > James T. Metz, Ph.D.
> > Research Investigator Chemist
> >
> > GPRD R46Y AP10-2
> > Abbott Laboratories
> > 100 Abbott Park Road
> > Abbott Park, IL  60064-6100
> > U.S.A.
> >
> > Office (847) 936 - 0441
> > FAX    (847) 935 - 0548
> >
> > james.metz@a...
> >
> > This communication may contain information that is legally
> privileged,
> > confidential, or exempt from disclosure.  If you are not the
> intended
> > recipient, please note that any dissemination, distribution, use,
> or
> > copying of this communication is strictly prohibited.  Anyone who
> receives
> > this message in error should notify the sender immediately by
> telephone or
> > return email and delete it from his or her computer.