Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
ENTHU
Level III

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
Highlighted
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
Highlighted
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

Highlighted

Re: Delete all rows except row 1.

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

Learn it once, use it forever!
Article Labels

    There are no labels assigned to this post.