topic Sorting a column with a script in Discussions

Sorting a column with a script

whom — Wed, 12 Dec 2012 03:13:41 GMT

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.

Re: Sorting a column with a script

ms — Wed, 12 Dec 2012 08:02:20 GMT

Try this syntax:

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

Re: Sorting a column with a script

whom — Wed, 12 Dec 2012 13:14:55 GMT

Adding the Replace Table did the trick. Thanks!