Remove multiple rows from a data tatble specificalled indexes from 0 to 54

Help
1

Hi, How do i Remove multiple rows from a data table specifically indexes from 0 to 54?

2

If you just want to delete the first 55 rows (0-54) you could just use Skip method like this: dtVariable.AsEnumerable.Skip(55).CopyToDataTable.

If you want to delete every row after the index 54, you could use Take method like this: dtVariable.AsEnumerable.Take(55).CopyToDataTable.

For more complex things you could use a combination of both. Take a look at the documentation for more information about Skip and Take.

4 Likes
3

Thank you. Forgive me as i am new. do i put the expression you mentioned into an assign activity and assign it to the datatabel variable?

4

No problem, we’re all here to learn!!

That’s correct, what you need to do is assign that expression to a data table variable. You should consider if you are going to need the complete table afterwards, if that’s the case, you should create a new variable to assign the expression to.

5

agreed!! RPA is amazing.

Ok that makes sense. Its a tricky case because in a whole i need to filter the rows like the below and then output the rows to keep to particular columns in an excel spreasheet.

Column1
row1[Value1] < Skip
etc…
etc…
row54[Value54] < Skip
row55[Value55] < Keep and then assign to column1 in new datatable
row56[Value56] < Keep and then assign to column2 in new datatable
row57[Value57] < Keep and then assign to column3 in new datatable

6

Would be i be on the right track using your expression to skip and then i need to assign the remaining rows to a datatable

7

Not sure the best way to do this?

8

There are a few ways to do this, a simple solution would be to do this four assigns:

  • dtReduced = dtComplete.AsEnumerable.Skip(55).CopyToDataTable
  • dtCol1 = dtReduced.Copy
  • dtCol2 = dtReduced.Copy
  • dtCol3 = dtReduced.Copy

And then remove the columns you don’t want from each new datatable (dtColX).
This is messy and definitely not the best solution, but it’s the easiest one. When I get home I can send you a better solution, that has the column filtering at the same time that you are copying the table.

9

Thank you. Each dtcol you mean are seperate data tables are they?

That would be great!!

10

Yes!

Another solution could be using Filter Data Table activity to create the dtCol variables.
I attach this example to help you start: SkipAndTake.xaml (9.4 KB)