How to Remove odd rows in the datatable

[Pujari_Manjunatha]

Here is the Data which i have extacted

Thanks in Advance.

[Yoichi]

Hi,

Which row do you want to keep?

If “Castle Biosciences, inc” , “The Real Good Food Company, Inc” etc. the following works.

dt = dt.AsEnumerable.Where(Function(r,i) i mod 2 =1).CopyToDataTable

If “CSTL”, “RGF” etc, the following will work.

dt = dt.AsEnumerable.Where(Function(r,i) i mod 2 =0).CopyToDataTable

FYI: As index of DataRow is 0-based, odd and even row are opposite against 1-based.

Regards,

[Manju_Reddy_Kanughula]

@Pujari_Manjunatha

Why do you want remove odd Rows? Is it for loop?

Happy Automation.

[Pujari_Manjunatha]

Yes Exactly, It goes to different pages, then scrapes the data and sends mail.
Things are there; odd rows have blank data, so only I want to remove them.

[Manju_Reddy_Kanughula]

@Pujari_Manjunatha

How about this.

Create Variable in the For each row properties like below screenshot

then use if condition keep this is in it "( Index Mod 2) = 0 "

Happy automation