UiPath Go ! Datatable Activities

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


image


Regards
Balamurugan.S

3 Likes

Hi Mr.Bala,

Installed BalaReva activities and I could not see data table extensions and aggregation activities. How to get it ?

Kulandaivel

1 Like

Hi,
It is in DataTableExtensions like in the above image.

Regards
Balamurugan.S

Nice, good job!
I will check them out right away :slight_smile:

1 Like

Thank you Mr.Bala. It’s there and I got it.

Kulandaivel

1 Like

Welcome @kulandai

Thank you
Balamurugan.S

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

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.

1 Like

Hi @pomaaa,

Welcome to UiPath Community Forum.
Can you attach the xmal or screen shot !

Regards
Balamurugan.S

Hi,

It’s in the attachment.

DataTableAggregation.xaml (10.6 KB)

1 Like

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

3 Likes

Can you check now please and let me know if everything is ok?

Thank you!

3 Likes

Thank you @Andreea_Stroe. It is bringing the latest version.

Balamurugan.S

1 Like

Hi @pomaaa,

Just update the latest version . And check it.

Regards
Balamurugan.S

2 Likes

Hi @balupad14,

It’s working now. Thank you very much :slight_smile:

2 Likes

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

OutPut :

Xmal format :

Sample : Phyomt.zip (27.3 KB)

Regards
Balamurugan.S