Choose Language Hide Translation Bar
Highlighted
Level I

## 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
Highlighted
Super User

## Re: Sorting a column with a script

Try this syntax:

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

2 REPLIES 2
Highlighted
Super User

## Re: Sorting a column with a script

Try this syntax:

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

Highlighted
Level I

## Re: Sorting a column with a script

Adding the Replace Table did the trick.  Thanks!

Article Labels

There are no labels assigned to this post.