Choose Language Hide Translation Bar
skyzvoir0001
Contributor

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.

0 Kudos
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