cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
whom
Level II

Sorting a column with a script

I have a file (mydata.jmp) and I manually sort the Temperature column (right click, and then Sort).

I'm trying to automate this in a jmp script.  what's the correct command so the column is sorted and the new file retains the original file name.  I have tried a few commands and the result of the sort command creates a new unnamed file, which is NOT what I want.  

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Sorting a column with a script

Try this syntax:

dt << sort( by( col ), Replace Table );

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Sorting a column with a script

Try this syntax:

dt << sort( by( col ), Replace Table );

whom
Level II

Re: Sorting a column with a script

Adding the Replace Table did the trick.  Thanks!