Trying to create separate Excel files of 500 rows with a single datatable of 10000+

[AryanS (Aryan Singh)]

Hello Everyone

I am trying to create separate datatables or excel file with only 500 rows at a time from the main datatable of 10000+ rows.

Main Datatable : 10000+ rows
Individual Datatables : 500 rows

How to pick up the next 500 rows?

Thanks and Regards
Aryan

[prasath17 (Guru)]

@AryanS - Please check this post…

To split a big CSV file into mutiple csv's

Hi –yah thats possible –use READ CSV FILE activity and pass the filepath as input and get the output with a variable of type datatable named dt –followed by that use a while loop activity with a condition like this counter > dt.Rows.Count where counter is a variable of type int32 with default value as 25000 defined in the variable panel –inside the loop use a assign activity like this dt1 = dt.AsEnumerable().Skip(dt.Rows.Count-counter).CopyToDatatable() where dt1 is a variable of type sy…

and this

Split Datatable into 4 different tables

@thomasb82 lets assume following variables: [grafik] NoOfSegments is indicating how many splits we do want have Doing an integer division to find out how many rows will be in a split (we cannot fetch a rows count with fractions e.g. 14.25 rows [grafik] with following LINQ we can produce a list of datatables with the splits: [grafik] (From i In Enumerable.Range(0,NoOfSegments) Let opart = dtData.AsEnumerable.Skip(i*FullSegmentSize).toList Let spart = If(i = (NoOfSegments - 1), opart, opar…

[Manish540 (Manish Shettigar)]

Check this below workflow, @AryanS
Uipath_TakeParticularCountRecords.xaml (7.4 KB)
Hope this may help you