- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Delete all rows except row 1.
How would you do it interactively? Translate those steps into JSL, as Jim did.