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
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!