215037_en-US

liliconcom

Re: Remove dupilcates

Go to

     Rows==>Row Selection==>Select Duplicate Rows

You can then right click on any of the selected rows, and select Delete Rows

Re: Remove dupilcates

@txnelson Thanks that worked!! Another quick question there are matching values in these two different columns but they are not aligned and some by default have 00 in front of it... I want align them the matching and keep the once which are unmatched with a blank in the opposite column...

 

Thanks !!

 

In the table below their are two colums

0012345	112345
67890	010012
00234234	98643
23467	67890
987643	234234
112345	23647
010012	12345
Missing value	90603
110233	110233

Remove dupilcates

Hi JMPcommunity,

 

So here is a basic question... How to remove duplicates ?

 

2nd question - How to keep important infomration like Blood Pressure, Month of visit and Insurance linked to the Pt_name and study ID.

 

Thank you!!

 

For example,

Study ID Pt_Name DOB Blood Pressure Month of visit Insurance 1 x 1/2/2019 120-60 Jan Private 1 x 1/2/2019 90-110 Feb Private 1 x 1/2/2019 120-80 March Private 1 x 1/2/2019 120-80 April Medicare 2 y 5/6/2019 120-97 Feb Private 2 y 5/6/2019 120-78 March MassHealth 2 y 5/6/2019 110-90 April MassHealth 2 y 5/6/2019 150-90 August MassHealth 2 y 5/6/2019 120-60 December MassHealth