Remove dupilcates

Apurva14

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

txnelson

Go to

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

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