Simplifying robot execution running time

[ppr (Peter Preuss)]

A general flow could look like following:

• retrieve all Distinct Due Date Values
• optional calculate min, max due date
• prepare a new empty datatable and create dynamically the different needed duedate cols - dtTarget

process the origin datatable by grouping the data
prepare a new empty dttarget data row with the values from the group members and add it

with some arrangements we would recommend the parallel for each activity for transponation step

Grouping the data have a look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…