This project won 1st prize in the PowerUp Automation Challenge organized by UiPath .
Create Consolidated Data Tables merging a list of multiple data tables where we can also
- Dynamically Create new columns on the fly
- Apply filter based on some conditions
- Sort the data table by desc, asc
- Top N Rows
- Apply Excel formula on the fly
- Remove duplicates
- InputDTList : (List<DataTables>)
- AQLString (String)
- ResultDT (DataTable)
Awesome Query Language (AQL)
Lets say there are 4 different datatables with same schema then we can apply a series of operations as mentioned below using this custom activity
1+2+3+4 | Remove-Duplicates | where Salary > 40000 | Order By Salary Desc | Select SNo=Row(SNo), FirstName, LastName, EmployeeName=FirstName&LastName, Salary, EmployeeType , YearlySalary =Salary*12 | Top 5
Note: the above usecase is just an example to show that we can create any such series of operations on the fly with this custom activity
In general, the same series of operation will take around 14 hours if performed manually. With this custom activity it will take just take few seconds to form this query using AQL.
Watch the AQL Explanation :
Need Any Help regarding the Explanation ? Click here to reach out to the developer.
Sudheer Nimmagadda is a Automation Developer based out of Bangalore, India. He has over 8 years of software industry experience in various roles including Software Module Lead, SSIS Developer, Dot Net Programmer, and Automation Lead. Sudheer was completed certifications like UiPath Foundational , Orchistrator, SAP Automation and he participated in UiPath Power Up Automation Program in UiPath Headquarters Banglore , India .