Split Datatable with Fixed Number of Rows

@nestor.zarallo
welcome to the forum

find starter help here:
DTSlice_BySegmentSize_ToTableList.xaml (10.5 KB)

UPDATE:
When working within a Project with set ProjectCompatibility to Windows we can do:
Assign Activity:
TableList | List(of DataTable) =

dtData.AsEnumerable.Chunk(intChunkSizeVar).Select(Function (x) x.CopyToDataTable).ToList

intChunkSizeVar | int32 = 40000

2 Likes