BalaReva.DataTable.Activities 1.1.0

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.

Installation

UiPath Studio

Package Manager -> Right Click -> Configure Sources -> Add https://gallery.uipath.com/api/v2.

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).
4.DataTable to XML Document.
5.DataTable to XML File.
6.Sum,Count,Avg, Max, Min.

1.Add Data Row Range.

It allows to add collection of datarow into DataTable.

2.Remove Data Row Select

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

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

AggregationBy : It has list of aggregation functions Sum,Count,Max,Min and Avg.By default it is Sum.

AggregationColumn : Here have to specifiy only one column.Should not allow more than one column.

AggregationType: Specifying the aggregation column datatype.(Integer,Double and DateTime)
The "DateTime" datatype supports only the Max and Min functions.
Normally if we read the data from excel, all columns are an Object datatype.So have to change the datatype like Integer or Double to do the aggregation.By default it is Integer and equal to Int64(C#.Net).

GroupByColumns: It allows more columns . Separated by comma(,) symbol.

4.DataTable to XML Document.

Writes as XMLDocument .

5.DataTable to XML File.

Save as XML File

InputTable: It is a datatable like Source data.

Result: DataTable.

6.Sum,Count,Avg, Max, Min.

It is a individual activity to do the Sum,Count,Avg, Max and Min for single column of datatable.

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)

You can get the samples in the below link
https://forum.uipath.com/t/balareva-datatable-activities/30768/2?u=balupad14

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).
4.DataTable to XML Document.
5.DataTable to XML File.
6.Sum,Count,Avg, Max, Min.

1.Add Data Row Range.

It allows to add collection of datarow into DataTable.

2.Remove Data Row Select

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

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

AggregationBy : It has list of aggregation functions Sum,Count,Max,Min and Avg.By default it is Sum.

AggregationColumn : Here have to specifiy only one column.Should not allow more than one column.

AggregationType: Specifying the aggregation column datatype.(Integer,Double and DateTime)
The "DateTime" datatype supports only the Max and Min functions.
Normally if we read the data from excel, all columns are an Object datatype.So have to change the datatype like Integer or Double to do the aggregation.By default it is Integer and equal to Int64(C#.Net).

GroupByColumns: It allows more columns . Separated by comma(,) symbol.

4.DataTable to XML Document.

Writes as XMLDocument .

5.DataTable to XML File.

Save as XML File

InputTable: It is a datatable like Source data.

Result: DataTable.

6.Sum,Count,Avg, Max, Min.

It is a individual activity to do the Sum,Count,Avg, Max and Min for single column of datatable.

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)

You can get the samples in the below link
https://forum.uipath.com/t/balareva-datatable-activities/30768/2?u=balupad14

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
1.1.0 (current version) 19,913 5/23/2018