Split datatable into batches

[ppr (Peter Preuss)]

can be done with skip take:

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

in the combination with copytodatatable split results are datatables:

Split Datatable with Fixed Number of Rows

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