Split the output data table into smaller data table which contain 50 rows per data table

[Ritesh_Burman (BotMaker)]

Hi,

• Read excel input contain more than 500 rows
• Split the output data table into smaller data table which contain 50 rows per data table.
• Log message for each small data table row count

How to approach this one? I am not finding any Good logic to do it. Please put some hints or share xaml file.

[ppr (Peter Preuss)]

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

Split datatable into batches

can be done with skip take: in the combination with copytodatatable split results are datatables:

[Rahul_Unnikrishnan]

Hello @Ritesh_Burman

One approach is as below:
1)excel scope
2)use find first/last row to get the last row number
3) use assign and then use the last row number %50 to get the number of small sets(50 rows) ( sectionVar)
4)use while loop (i<=sectionVar)
5) Read range to get output in data table variable( range need to be dynamic by passing x+50 ( where x is an integer variable declared as zero)

I think this should work for you…So range will get increase as 50,100,150 like that

A0:B50, A50:B100 etc

[ppr (Peter Preuss)]

@ppr

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

can be done with skip take: in the combination with copytodatatable split results are datatables:

In Additiona 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()

[ppr (Peter Preuss)]

You can modify the XAML from the Links shared above