delete rows

skyzvoir0001 — Thu, 23 Jan 2020 01:23:28 GMT

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.

Re: delete rows

txnelson — Thu, 23 Jan 2020 04:30:21 GMT

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.

topic delete rows in Discussions

delete rows

Re: delete rows