nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

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;

All comments

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;

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

Quick Links