Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

Article Labels

    There are no labels assigned to this post.