delete rows

[#1]

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.

[#2 · Accepted solution]

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.