topic Re: How does JSL's sorting operation not create a new window? in Discussions

How does JSL's sorting operation not create a new window?

lwx228 — Mon, 10 Sep 2018 10:43:40 GMT

The result of sorting will not create a new window.But the same sort operation using the following JSL will produce a new window to display the sorted results.How do you make a JSL sorting operation not generate a new window?thank you!

dt = Current Data Table();
dt<<Sort(By(4),Order(descending));

Re: How does JSL's sorting operation not create a new window?

txnelson — Mon, 10 Sep 2018 12:20:05 GMT

Here is the example from the Scripting Index

Help==>Scripting Index

that illustrates the Replace Table option for the Sort Platform

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Sort(
	replace table,
	By( :name ),
	Order( Ascending )
);

Re: How does JSL's sorting operation not create a new window?

pmroz — Mon, 10 Sep 2018 12:21:16 GMT

It's in the scripting index. Look for sort and you'll see all of the options.

dt = Open( "$sample_data\Big Class.jmp" );
dt << Sort( By( 4 ), Order( descending ), replacetable( 1 ) );

Re: How does JSL's sorting operation not create a new window?

lwx228 — Mon, 10 Sep 2018 13:10:47 GMT

replacetable

thanks you!