Situation :

In the technology world,we use the Excel frequently to maintain the data except the custom applications(Winform or Web). It is look like front-end database.In Uipath , While read the data from excel, It keeps all the data are in string. When perform the aggregation with columns.It is so hard. Because we need to convert the column datatype string to integer or double.And then we do the aggregation.

Solution :

I have developed the package with activities called "BalaReva.Datatable.Aggregation.Activities". It solves the problem of the above situation. Below the activities details.

1.Avg Activity – To find the average to the specified column of the datatable.

2.Count Activity – To find the count to the specified column of the datatable.

3.Max Activity – To find the maximum to the specified column of the datatable.

4.Min Activity – To find the minimum to the specified column of the datatable.

5.Sum Activity – To find the sum to the specified column of the datatable.

Features:

1.It has an option to add the default value to the null. 2.Can able set the where condition to the datatable by using of "Select" Property.

Future:

Have to add more functionalities in the activities.

Flexibility and Usability:

This is the power of UiPath. It is very flexibility to the developers to develop the custom activities. After the development, it is very easy to use it. I have Developed activities in C#.Net.

Share this project:
×

Updates