Removing rows after specified cell

[E.T.S]

Hello,

I am wanting to use an assign activity to say if there are any rows after cell A5 in a data table that are empty remove the rows

Please advise how to configure

Cheers

[RajKumar_DC (RajKumar Durai)]

Hi @E.T.S ,

use filer datatable activity like this.

Thanks,

[pikorpa (Piotr Kołakowski)]

Hey @E.T.S
did you try this:
YourDataTable.AsEnumerable().Take(5).Concat(YourDataTable.AsEnumerable().Skip(5).Where(Function(row) Not row.ItemArray.All(Function(field) String.IsNullOrEmpty(field.ToString())))).CopyToDataTable()

[E.T.S]

Hi!

Thanks for your reply - the suggested method cuts the table too short

Cheers

[E.T.S]

Hi!

Thanks for your reply

My data table has 100 rows therefore it would take a while to configure this activity

[E.T.S]

I could remove all rows in data table - but then I need to insert a row in row 5, please advise how to insert rows at a specific point (row 5) in a data table

Cheers

[E.T.S]

I have managed to find a solution : https://www.youtube.com/watch?v=A-ZWCvUgUVU

This video explains how to insert rows using the invoke method

Cheers