Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
Apurva14
Level II

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 IDPt_NameDOBBlood PressureMonth of visitInsurance
1x1/2/2019120-60JanPrivate
1x1/2/201990-110FebPrivate
1x1/2/2019120-80MarchPrivate
1x1/2/2019120-80AprilMedicare
2y5/6/2019120-97FebPrivate
2y5/6/2019120-78MarchMassHealth
2y5/6/2019110-90AprilMassHealth
2y5/6/2019150-90AugustMassHealth
2y5/6/2019120-60DecemberMassHealth
AD14
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

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

Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

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

Jim

View solution in original post

Highlighted
Apurva14
Level II

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

0012345112345
67890010012
0023423498643
2346767890
987643234234
11234523647
01001212345
Missing value90603
110233110233
AD14
Article Labels

    There are no labels assigned to this post.