Sub Activity – DataTable
DataTable works with tabular data structures within your automation workflows, providing tools to create, modify, and query DataTables for efficient data handling.
The DataTable category has the following sub activities:
Add Data Column: This activity adds a Column to a specified Data Table.
Input Properties:
- Datatable : The DataTable variable to which the user want to add columns.
- ColumnName: Specifies the name of the new column to be added.
Add Data Row: This activity adds a Row to a specified Data Table.
Input Properties:
- Datatable : The DataTable variable to which you want to add rows.
- Items: Specifies an array of new rows to be added to the DataTable.
Build DataTable: This activity Allows users to build and customize a datatable.
Input Properties:
- Build: Allows to customize a table.
Output Properties:
- Datatable: Stores the added information in the DataTable.
Clear DataTable: This activity clears all the data from a specified DataTable.
Input Properties:
- Datatable: The DataTable variable to be cleared.
Column Exists: This activity allows verification of the existence of a specific column in a table data structure during automation execution.
Input Properties:
- Datatable: The DataTable variable to check for the column’s existence.
- ColumnName: The name of the column to check for existence.
- ColumnIndex: The index of the column to be referenced.
Output Properties:
- Exists/DoesColumnExist: Indicates whether the column exists.
Data Table Filter: This activity is used to filter a datatable by including/excluding specific rows/columns according to the given rule.
Input Properties:
- Options: The Data Table Filter Window allows to customize the table to filter.
- Datatable: The DataTable variable to be filtered.
Output Properties:
- Datatable: The resulting filtered DataTable variable.
Delete Column: This activity deletes particular columns from a specified datatable.
Input Properties:
- Datatable: The DataTable variable from which you want to delete column.
- ColumnName: The name of the column to delete.
- ColumnIndex: The index of the column to delete.
Delete Row: This activity is used to Delete particular rows from a specified DataTable.
Input Properties:
- Datatable: The DataTable variable from which you want to delete row.
- RowIndex: The index of the row to delete.
Join DataTable: This activity is used to combine rows from two datatable by using values common to each other, according to a Join rule.
Input Properties:
- Join Wizard: Enables joining of two tables.
Output Properties:
- Datatable: It stores the two datatable after joining common information in the datatable variable.
Merge DataTable: This activity is used to merge a specified datatable with the current datatable.
Input Properties:
- Destination: Specify the DataTable into which the data should be merged.
- MissingSchemaAction : Specifies the action to take when merging the two datatables.
- Source: The DataTable object to be added to the destination Datatable.
Preview DataTable: This activity lets the user view all the values for all the rows and columns in a DataTable.
Input Properties:
- DataTable : A DataTable variable that stores the added information in the Build DataTable window.
Row Exists: This activity allows verification of the existence of a specific row in a table data structure during automation execution.
Input Properties:
- Datatable: The DataTable variable to check for the row’s existence
- ArrayRow: array of rows to be checked
- RowIndex: The index of the row to be referenced.
Output Properties:
- Exists/DoesRowExist: Indicates whether the row exists.