Hi All,
Here you can get the datatable related activities.
This package includes the below activities that can handle the Aggregation, Cumulative, Add - Delete row range and Export to Xml
1.Add Data Row Range.
2.Remove Data Row Select.
3.Group By Aggregation (Sum,Count,Avg, Max, Min).
4.DataTable to XML Document.
5.DataTable to XML File.
6.Sum,Count,Avg, Max, Min.
Name Space 
https://go.uipath.com/component/datatable-related-activities
Regards
Balamurugan.S
Hi Mr.Bala,
Installed BalaReva activities and I could not see data table extensions and aggregation activities. How to get it ?
Kulandaivel
Hi,
It is in DataTableExtensions like in the above image.
Regards
Balamurugan.S
Nice, good job!
I will check them out right away
Thank you Mr.Bala. It’s there and I got it.
Kulandaivel
Hi All,
I have added a new activity in this package called Native Group Aggregation.
Here I have attached the Video and Sample Project Also. Using this activity . can able to do Sum,Max,Min and Count in a single activity.
Video :
Sample :
DataTableAggregation.zip (25.9 KB)
Thank you
Balamurugan.S
Hi,
Firstly, thanks for a great addon.
I have tried using native Group Aggregation however when I insert multiple Group by Columns ({“EmployeeName”, “Description1”,“Description2”}) I get the following error:
RemoteException wrapping System.Exception:
System.NullReferenceException: Object reference not set to an instance of an object.
at DataTableExtensions.NativeGroupAggregation.10AA0()
at DataTableExtensions.NativeGroupAggregation.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance,
ActivityExecutor executor,
BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,
BookmarkManager bookmarkManager,
Location resultLocation)
I have tried using your UiPath project and get the same error.
Hi @pomaaa,
Welcome to UiPath Community Forum.
Can you attach the xmal or screen shot !
Regards
Balamurugan.S
Hi @pomaaa,
Yes . you are right. I have fixed this error in the version 2.0.2. But in the manage package is showing only the older version.
Manage package :
UiPath Go !
Thank you for your feedback.Let ping the UiPath go Contact. And I will ask them to update the latest one in the Package Mange.
I just tagged @Andreea_Stroe here.
Thank you
Balamurugan.S
Hello,
Thank you for bringing this to our attention. We will look into it and keep you posted.
Warm Regards,
Andreea & Go! Team
Can you check now please and let me know if everything is ok?
Thank you!
One example for Native Group Aggregation.
Have to get the Max “Available Balance”
respective of the “Account Number”. So it has to be grouped by “Account Number” for the “Available Balance”. And the output should have the “Name” and “City”.
This activity doesn’t convert the datatable’s column dataType , we have to use an activity from @Jyotsna UiPath Labs to convert datatype . I have illustrated an example for you.
Input :
OutPut :
Xmal format :
Sample : Phyomt.zip (27.3 KB)
Regards
Balamurugan.S
the group by aggregation does not work. It gives a syntax error
Hi ,
Can you please share the sample workflow with project.json ?
Regards
Balamurugan.S
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu