DatatableAutomation

DataTable Automation in Robility provides a versatile way to organize, analyze and manipulate tabular data, known as datatables. Integrate DataTable Automation in your workflows to enhance and enrich data-driven automation. This documentation serves a comprehensive guide to understanding and implementing DataTable Automation within your automation workflows.
Before delving into automation, acquire the skills to import data from diverse sources like CSV files, databases, and websites into data tables for subsequent processing. 
The following inputs are intended for the “Datatable” automation and can be utilized: 

1. “HTML Table” can be extracted as response from “Websites”.
2. “Datasets” can be returned as output response from the “Rest” or “Json” activity.
3. Range can be extracted from the excel sheet.
4.In “Database” automation, we can extract the response as “datatable” output.
5. In “WebAutomation” and “Desktop” automation we can extract the “Attributes” and its “elements as “Datatables”.
6. In “PDF” automation, the “Tables” from the pdf can be extracted as response.

UseCase

Below are the use cases where the “Datatable” Automation can be useful in Robility.

• Data Transformation: Use it to structure raw data into a Datatable by removing duplicates, handling missing values, and eliminating unnecessary ones.
• Data Comparison: Utilize “DataTable” automation to validate and compare data extracted from Excel sheets, updating values as needed.
• Data Parsing: Extracted values from Excel sheets can be filtered to retain specific rows and update the sheet.
• Data Validation: To optimize memory usage, clear extracted “DataTables” from Excel sheets before proceeding to the next step in automation.
• Data Troubleshooting: Troubleshoot extracted “Datatable” to ensure the accuracy of values extracted from websites.
• Data Merging and Joining: Automate the merging or exclusion of values in similar extracted “Datatable” from websites using “Datatable” automation.