BalaReva.DataTable.Activities


#1

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


DataTable Group By Sum,Count,Max,Min,Avg
DataTable Add Row Range, Delete Row with condition where
#2

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

You can find the Activities in DataTableExtensions NameSpace

image

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

Sample File : AddDataRowRange.zip (7.8 KB)

  1. 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)

  1. 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)

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

Sample File : XmlDocument.zip (7.6 KB)

  1. 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.

Regards
Balamurugan


Total of excel column
Stuck to create a summary data from excel
Delete data row from data table
How to remove a row from a Excel Data Table?
Sum of column groupped by identifier
Delete Row in excel
Add row to ARRAY of DataRows - DataRow[]
How to convert a table to pivot table with sum of a particular column
How to sum the data in excel based on the product?
How to insert Group by data from old Data table to a new table?
How to Delete or Remove Data Row using a WHILE LOOP
#3

Here you can see the quick reference by the picture

Regards
Balamurugan


Sum of column groupped by identifier
#4

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

You can see in the below namespace

image

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


Sum of a ligne of a column
How to sumup String values in a datatable
#5

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

Any idea? Thanks

Lavina


#6

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.


#7

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


#8

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


#9

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


#10

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
image

and
image

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


#11

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)

image

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

Regards
Balamurugan.S


#12

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


#13

Thank you @lavint


#14

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?


#15

Hi @Selvasathappan,

Can you please check this ?

Regards
Balamurugan


#16

Hi

Can you please click the All and check it. ?

Regards
Balamurugan.S


#17

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


#18

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


#19

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


#20

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

Regards
Balamurugan.S