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.
Go to 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.
View solution in original post