cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
skyzvoir0001
Level III

delete rows

I have several data sets from excel. My question is that how do i delete the last two rows using scripting regardless of how many number of rows -- i only need to remove the last two rows since its of no use.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: delete rows

names default to here(1);
dt = current data table();

dt << select where(row() >= N Rows(dt) - 1;
dt << delete rows;

The above script should do the trick.  Just make the data table of interest your active data table(click on the table), and then run the script.

Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: delete rows

names default to here(1);
dt = current data table();

dt << select where(row() >= N Rows(dt) - 1;
dt << delete rows;

The above script should do the trick.  Just make the data table of interest your active data table(click on the table), and then run the script.

Jim