cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

Table: sort by multiple columns?

How can I sort a table by multiple columns.

In a data table, when I select multiple columns and sort the table via right click:

hogi_0-1721478591886.png

 

the table is always sorted from "left to right" - the sort column on the left is the dominant one
... even if I change the order in which I select the columns.

 

Via JSL, I can adjust the order:

dt  << Sort(By( :sex, :age ));

dt  << Sort(By( :age, :sex ));

How to do the trick via the GUI?

 

Another question:
How to sort TableBoxes by multiple columns?

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Table: sort by multiple columns?

1 REPLY 1
jthi
Super User

Re: Table: sort by multiple columns?

Use Sort platform

jthi_0-1721479198026.png

jthi_1-1721479205997.png

 

-Jarmo