cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
hogi
Level XI

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