cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.

Sorting by columns

Sorry to display my ignorance but how do I sort a datafile by column entries?
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sorting by columns

As stated above,

 

If you only want to sort by one column, you can right mouse click on the header of the column and the second to the last option is sort. To sort it the descending, sort it again with the right mouse click.  Alternatively, Tables->Sort will work, and is the way to go for sorting by multiple columns.

Duane Hayes

View solution in original post

4 REPLIES 4

Re: Sorting by columns

If you look under the table menu, there are a bunch of commands for reorganizing data tables. One of these is sort. You can add the column(s) of interest and specify ascending or descending. JMP can then either replace your table or create a new one.

Re: Sorting by columns

One way is go to Table > Sort

Re: Sorting by columns

If you only want to sort one column, you can right mouse click on the header of the column and the second to the last option is sort. To sort it the descending, sort it again with the right mouse click.

Re: Sorting by columns

As stated above,

 

If you only want to sort by one column, you can right mouse click on the header of the column and the second to the last option is sort. To sort it the descending, sort it again with the right mouse click.  Alternatively, Tables->Sort will work, and is the way to go for sorting by multiple columns.

Duane Hayes