cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
ENTHU
Level IV

Delete all rows except row 1.

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

How can I do this?

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Delete all rows except row 1.

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;
Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Delete all rows except row 1.

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;
Jim

Re: Delete all rows except row 1.

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