Introduction

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. 

Use Cases

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.
 

To see the activities available in DataTable Automation, click on the link below.

Activities