Split DataTable Based On Number Of Rows

[satish_kumar]

Hello All,

There is datatable with 1lakh Plus Rows.

I want to split that datatable based on number 10000.

For example If I have a datatable with 25000 rows. After Splitting it the output has to be 3 datatables with 10000,10000,5000 rows.

My work : I was able to create a list of datatable but i am unsure of splitting the datatable based on a specific count. Any help would be appeciated.

Thanks & Regards,
Sateesh.

[ppr (Peter Preuss)]

Have a look here:

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: …

And starter help for the returned tablelist

Split Datatable with Fixed Number of Rows

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

[satish_kumar]

I am sorry but I didn’t quite get that. can you please elaborate each step clearly that needs to be followed in uipath. so that it would help.

Thanks

[ppr (Peter Preuss)]

Can you have a Look at the shared xamls?
In one of the links also an explanation on the approach is given