topic Re: Duplicate Rows in Discussions

Duplicate Rows

timothy_forsyth — Mon, 12 Feb 2024 18:41:04 GMT

I have a table in in JMP 16.0 that has duplicate rows with respect to one of the columns. I would like to retain the first row and delete all the following rows. For example from Table 1 to Table 2.

Table 1

Table 2

Re: Duplicate Rows

jthi — Mon, 12 Feb 2024 18:59:26 GMT

There are many options of doing this. One which might work in this case is to use Select Duplicate Rows

Select your column you wish to use for "unique" selection and go to that selection, select rows and delete extra rows