Hi
If I have data in excel file 20 rows that I want to proceed in “For each row” activity but I would like to proceed only 5 rows in each loop. How can I specify row number for each loop in this activity?
Regards,
Sathika
Hi
If I have data in excel file 20 rows that I want to proceed in “For each row” activity but I would like to proceed only 5 rows in each loop. How can I specify row number for each loop in this activity?
Regards,
Sathika
@sathikaotk
In general it can be done with take and skip
taking the first 5 rows:
yourDatatableVar.AsEnumerable.Take(5)
appending .toList, getting a List of Rows, .CopyToDataTable, getting a DataTable
taking row 5 to 10
yourDatatableVar.AsEnumerable.Skip(5).Take(5)