How to loop a datatable and pick only multiplication of 10th row only

Help Activities
,
1

I would like to loop a data table and pick only rows which are in the iteration of 10 like row no#10, 20,30 etc till the end of total rows?

2

@raja.mahajan
welcome to the forum

give a try on following:
for each activity - item - Typeargument: DataRow - Values: YourDataTableVar.AsEnumerable.Where(Function (x, i) i Mod 10 = 0).Skip(1)

Statement will return 10, 20…th row and send it to processing implemented inside the for each body

3

16195687045719032010134150510741
161956870457190320101341505107411512×2016 1.24 MB

4

Thanks you for your reply, Can you tell me where should i be putting the function you mentioned?

5

on the field right to in

6

Do I need to change the variable type instead of data table?

7

image

8

@raja.mahajan,

Can you try with below approach? it’s simple one and works as well.

boolLessThanTen = True
totalRow = dt.rows.count
while totalRow >=10 and boolLessThanTen {
if totalRow >=10 {
read file from A1:A10
delete first 10 rows,
after deletion, remaining rows 30 out of 40, 10 is already deleted.
}else{
write rows which are less than 10 or do what u wanna.
set a flag false or true.
boolLessThanTen = False
}
}

while loop will keep on running until and unless rows become less than 10 and boolean variable is marked as false.

give a try… it followed this approach for my requirement of 20000.

Cheers,
Pankaj

9

grafik
grafik

Find starter help here:
LoopOver_NthRow.xaml (7.3 KB)

10

Thanks you, it worked

11

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