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
IC
IC
Level I

How to merge two adjacent rows without a key column

Hello.

 

So I am analzying cricket batting averages for a project for school. I used the Internet Open option in JMP to get the data from the following site: http://stats.espncricinfo.com/indian-premier-league-2017/engine/records/averages/batting.html?id=117....

I get the table below which has the player statistics in one row and the team that the player is on in the row right below. Is there any way either through JMP or SAS that I can combine two rows so that for each player, I also have his team as well. An help would be appreciated. Thank you

 

cricket.PNG

2 REPLIES 2
Highlighted

Re: How to merge two adjacent rows without a key column

You could select the even rows, subset them into a new data table, delete the selected rows in the original data table, and then join the two tables with a match.

 

See Help > Books > Using JMP.

Learn it once, use it forever!
Highlighted
txnelson
Super User

Re: How to merge two adjacent rows without a key column

This question was previously asked in the discussion item

     

How do I merge two rows that don't have a key column

  

A suggested solution was included.  Is there an issue with the suggested solution?

Jim
Article Labels

    There are no labels assigned to this post.