topic Re: Delete all rows except row 1. in Discussions

Delete all rows except row 1.

ENTHU — Tue, 30 Oct 2018 18:05:10 GMT

I am working on a jsl script and need to delete all rows in a datatable except row 1.

How can I do this?

txnelson — Tue, 30 Oct 2018 18:12:16 GMT

Here is a simple solution.....all messages and functions used are documented in both the Scripting Guide and the Scripting Index

names default to here( 1 );
dt = Open( "$SAMPLE_DATA\Big Class.JMP" );

dt << select where( Row() > 1 );
dt << delete rows;

Mark_Bailey — Tue, 30 Oct 2018 19:01:36 GMT

How would you do it interactively? Translate those steps into JSL, as Jim did.