Awesome Data Table

Bronze Certified

Custom Activity

0 reviews

617

Awesome Data Table

Bronze Certified

Custom Activity

0 reviews

617


Summary

Manipulate multiple Data Table using query language

carouselImage0

Overview

Create Consolidated Data Tables by merging a list of multiple Data Tables and use the below functions:
  • Dynamically Create new columns;
  • Apply filter based on specific conditions;
  • Sort the Data Table information descendant/ascendant;
  • Top N Rows;
  • Apply Excel formula;
  • Remove duplicates.

AQLString:
Let’s say there are 4 different Data Tables with the same schema. For this type of information use this custom activity and apply the below series of operations:
  • Merge Data Tables (1+2+3+4);
  • Remove-Duplicates;
  • Filter Salary > 40000;
  • Order the Salary value descendent;
  • Select SNo=Row(SNo), FirstName, LastName, EmployeeName = FirstName&LastName, Salary, EmployeeType , YearlySalary =Salary*12 | Top 5
Input Parameters:
  1. InputDTList : (List<DataTables>)
  2. AQLString (String)
Output Parameters:
  1. ResultDT (DataTable)
  2. ResultCSV(String)

Benefits


Published: 2019-09-17T00:22:13+00:00 | Updated: 2020-12-18T00:00:08+00:00

sudheer nimmagadda
System Analist

Trivandrum, Kerala, India


License

MIT


Code Language

Visual Basic


Tags

data
datatable
excel
table

Compatibility

UiPath 2019.0.4


Dependencies

SQLite Excel



Similar Listings