Skip a row in the middle

Help Studio
, ,
1

I have a datatable with 300 rows, so i want to skip row number 200 how do i do it in UiPath

Please help

2

@Girid

datatable.AsEnumerable.skip(200)

Cheers!!

3

Hey @Girid ,

If you have a fixed rows that is you want to remove 200th row,
then u can use below Linq query

dtData.AsEnumerable().Take(199).Concat(dtData.AsEnumerable().Skip(200)).CopyToDataTable()

Hope it helps you!

4

Hi @Girid

Try this:

Assign activity:
    rowIndexToSkip = 200

Assign activity:
    dtFiltered = YourDataTable.AsEnumerable().Where(Function(row, index) index + 1 <> rowIndexToSkip).CopyToDataTable()

Hope it helps!!

5

If you are looping through it with For Each, you can the Continue activity. Just include it in an If where you check the current row’s index.

6

@Girid

You can do this as you know the row index…use the below in assign

Dt = Dt.AsEnumerable.RemoveAt(199).CopyToDataTable

As the index of 200 is 199 it rows row 200

Hope this helps

Cheers

7

Hey @Anil_G ,

I get error
error BC30456: ‘RemoveAt’ is not a member of ‘EnumerableRowCollection(Of DataRow)’.

8

This skipped all starting 200 rows

9

It worked thanks for it

10

It was too slow with activities

11

Glad it worked, kindly mark appropriate answer as solution and close this thread

1 Like
12

@Girid

Ah my bad…this is the one

Dt.Rows.RemoveAt(199) to be used in invoke code

or using invoke method

Glad you resolved anyways

Cheers

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.