Data Table sort by two columnsNormally data table can sort order by one column, just have left table shows, sort by column "Name".
but how to use JMP to sort by two column? order by both "Name" & 'Date", like the right table shows, kindly help to suggest.
thanks a lot.
| Name | Date | Accomplish amounts of work | --> | Name | Date | Accomplish amounts of work |
| John | 20/8/21 9:03:59 | 100% | Kevin | 20/8/17 9:03:57 | 60% |
| Kevin | 20/8/22 9:03:59 | 80% | Kevin | 20/8/18 9:03:57 | 40% |
| Kevin | 20/8/23 9:03:60 | 77% | Kevin | 20/8/19 9:03:58 | 50% |
| John | 20/8/20 9:03:58 | 67% | Kevin | 20/8/20 9:03:58 | 33% |
| Kevin | 20/8/17 9:03:57 | 60% | Kevin | 20/8/21 9:03:59 | 0% |
| John | 20/8/18 9:03:57 | 60% | Kevin | 20/8/22 9:03:59 | 80% |
| Kevin | 20/8/19 9:03:58 | 50% | Kevin | 20/8/23 9:03:60 | 77% |
| John | 20/8/19 9:03:58 | 50% | John | 20/8/17 9:03:57 | 40% |
| Kevin | 20/8/18 9:03:57 | 40% | John | 20/8/18 9:03:57 | 60% |
| John | 20/8/17 9:03:57 | 40% | John | 20/8/19 9:03:58 | 50% |
| Kevin | 20/8/20 9:03:58 | 33% | John | 20/8/20 9:03:58 | 67% |
| John | 20/8/23 9:03:60 | 23% | John | 20/8/21 9:03:59 | 100% |
| John | 20/8/22 9:03:59 | 20% | John | 20/8/22 9:03:59 | 20% |
| Kevin | 20/8/21 9:03:59 | 0% | John | 20/8/23 9:03:60 | 23% |
Data Blending and CleanupMass CustomizationRe: Data Table sort by two columns- If you select multiple columns, and then right click on them and select "Sort" the data table will be sorted by all selected columns.
- You can go to the Pull Down Menus and select Tables==>Sort and then select whatever columns and whatever ascending/descending combination you want.
The quickest way to get a background in these types of issues is to read a couple of documents in the JMP Document Library under the Help pull down menu.
Both, Discovering JMP, and Using JMP are excellent docs.
