How to split datatable for each iteration

[Parvathy (PS Parvathy)]

Hi @Kishore_Raj

Check out this thread

Split Datatable with Fixed Number of Rows

@nestor.zarallo welcome to the forum find starter help here: DTSlice_BySegmentSize_ToTableList.xaml (10.5 KB)

In Additional to above find a compacted variation:

Assign Activity:
SegmentSize | Int32 = 50

Assign Activity:
NoOfSegments | Int32 = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize))

Assign Activity:
TableList | List(Of DataTable) =

Enumerable.Range(0,NoOfSegments).Select(Function (x) dtData.AsEnumerable.Skip(x*SegmentSize).Take(SegmentSize).CopyToDataTable).ToList()
For each Activity: item in TableList | TypeArgument: DataTable

Log Message: item.Rows.Count.ToString()

Hope it helps!!