BalaReva.DataTable.Activities

UiRobot · April 30, 2018, 12:30pm

It has the custom activities for the easy functionality of datatable under the namespace of DataTableExtensions.

1.Add Data Row Range.
2.Remove Data Row Select.
3.Group By Aggregation (Sum,Count,Avg, Max, Min).

Package: BalaReva.DataTable.Activities
Author: @balupad14

balupad14 · March 28, 2020, 5:44pm

Hi Friends.
Below you have Documentation and Sample attachment for the “BalaReva.Datatable.Activities”

You can find the Activities in DataTableExtensions NameSpace

Add Data Row Range
It allows to add collection of datarow into DataTable.

Sample File : AddDataRowRange.zip (7.8 KB)

Remove Data Row Select
It allows to remove the data rows based on the Select(Where) condition from DataTable.

Sample File : RemoveDataRowSelect.zip (7.6 KB)

Group By Aggregation(Sum,Count,Avg,Max,Min)
The Group By Aggregation activity aggregate functions (Sum,Count,Max,Min,Avg) to group the result-set by one or more columns.

Sample File : GroupByAggregation.zip (8.1 KB)

DataTable to XML Document
It Writes the Datatable into a XMLDocument .

Sample File : XmlDocument.zip (7.6 KB)

DataTable to XML File.
It writes the datatable into a XML File.

Sample : XmlFile.zip (7.5 KB)

Note : To Know that how to add the Gallery Package into Studio. Please check it below.

Make sure the package is installed or not…

Regards
Balamurugan

balupad14 · May 23, 2018, 12:07pm

Here you can see the quick reference by the picture

Regards
Balamurugan

balupad14 · May 23, 2018, 12:23pm

Hi Friends.
I have included some activities in the package of BalaReva.Datatable.Activities

You can see in the below namespace

The key advantages are below
1.ConvertInputColumn - When you read the data from excel , it is always string format. Using this property can able change the data type and do the aggregation .
2.NullValue - If you have empty of null value in the data. can able to assign the default value for it.
3.Select- It is place to keep the condition(Where)

Sample File :SumActivity.zip (8.9 KB)

Let me if you have any errors.
I would be happy to get more suggestions .

Regards
Balamurugan

lavint · June 26, 2018, 3:37pm

Hi @balupad14 ,

I followed the instruction in https://gallery.uipath.com/packages/BalaReva.DataTable.Activities

but I don’t see a place where I can install group by activity…

Any idea? Thanks

Lavina

ovi · June 26, 2018, 3:54pm

Hi Lavinia,

I’m not sure I understand your requirement. In order to install the activity packs from the Gallery feed you can just search for the desired one.

lavint · June 26, 2018, 4:36pm

Thanks! FOund it under Available -> Package Source. Installed it and now it disappeared in the package manager again. oh well. but thanks!

ovi · June 26, 2018, 4:51pm

Set this as Gallery feed (if you don’t have CE): https://gallery.uipath.com/api/v2

lavint · June 26, 2018, 5:00pm

Thank you! I actually did this,

But still won’t be able to see the rest of the packages that he built but I didn’t install. I will restart UIPath and check again. Thanks a lot

lavint · June 26, 2018, 7:57pm

Hi @balupad14 ,

***Edit2: I found out that it’s because my column name has a space in it. Is there a way to go around it? ***

I have this error when using group by, what does that mean exactly?

Group By Aggregation : Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.

I output my original dt and did a messagebox
Looks like this

and

Edit: I tried to save it as in excel first and output as datatable but the aggregation still won’t work

Maybe it’s the datatype? How to fix that? Thanks

Thanks in advance!

Lavina

balupad14 · June 27, 2018, 3:25am

Hi @lavint,

First of all I thank you to use my activities. And Sorry for my late reply .

I don’t know your real situation. You can able to fix this issue by renaming the column name. Here I have attached a sample for you with output.

File : LavintSum.zip (12.4 KB)

Note : Special thanks to @ovi to give the guidance that to configure the package to the user.

Regards
Balamurugan.S

lavint · June 27, 2018, 1:55pm

Hi @balupad14 ,

I am aware of renaming the column name but I was just curious if there is a way to keep my original column names with a space in between - seems like there is no syntax for it. Anyway, thanks a lot! And thanks for building this package! It’s awesome.

Warm regards,
Lavina

balupad14 · June 27, 2018, 3:03pm

Thank you @lavint…

Selvasathappan · July 27, 2018, 1:35am

Hi @balupad14,

I am not able to install your package. I added gallery path as a source in Package Manager by right clicking it. However I don’t see it under any of the tabs in package manager. My Studio version is 2017.1.6682. Is it only suitable for recent versions? Please find the screenshot below. Though the text at the bottom of screenshot reads as “Showing available packages”, I don’t see anything to select. It is blank. Find the screenshots below

Can you please help me with it?

balupad14 · July 27, 2018, 6:21am

Hi @Selvasathappan,

Can you please check this ?

Regards
Balamurugan

balupad14 · July 27, 2018, 7:11am

Hi

Can you please click the All and check it. ?

Regards
Balamurugan.S

Selvasathappan · July 27, 2018, 8:05am

No @balamurugan. Still I couldn’t find it @balupad14. I also referred the relevant post earlier through which I came to know about your package but am not able to see it

balupad14 · July 27, 2018, 8:59am

Hi @Selvasathappan,

It is so strange .I think you are using the licensed version. I have the community version.But I will share my setting below

Regards
Balamurugan.S

Selvasathappan · July 27, 2018, 9:54am

Yes. It’s a licensed version. Will it not be available for a licensed version?

balupad14 · July 27, 2018, 9:57am

No @Selvasathappan. I will include this conversion @ovi and @badita

Regards
Balamurugan.S