Awesome Data Table

Bronze Certified

Custom Activity

0 reviews

583

Awesome Data Table

Bronze Certified

Custom Activity

0 reviews

583


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: Sep 17, 2019 | Updated: Dec 18, 2020

sudheer nimmagadda
System Analist

Trivandrum, Kerala, India


License

MIT


Code Language

Visual Basic


Tags


Compatibility

UiPath 2019.0.4


Dependencies

SQLite Excel