Data Table package
The Data Table package contains actions that enable you to perform various operations on the values of table variables. Use these actions to join or merge content, search for specific values, insert rows and columns, remove duplicate rows, and write values to a file.
Actions in the Data Table package
Action | Description |
---|---|
Assign | Assigns values to a table variable. You can use this action to manually enter the table data.
|
Change column type | Changes the data type of a column.
|
Clear content | Clears the contents of the specified table variable. This action clears the content until the execution of the bot is completed. After the bot execution is completed, the original values of the table variables are restored. The action enables you to reuse an existing table
variable to store values that are used only during the bot execution. Note: The data type of the
values must be same as the data type of the columns in
the table variable. |
Delete column | Deletes a specific column.
|
Delete row | Deletes a specific row. Note: If the data table values were
read from an Excel sheet, and you selected the
Sheet contains a header option in
the Open
action, you cannot delete cells from the
first row.
|
Get number of columns | Retrieves the number of columns and assigns it to a Number variable. You have the option to select the non-empty columns or include all the columns in the selection. |
Get number of rows | Retrieves the number of rows and assigns it to a Number variable. You have the option to select the non-empty rows or include all the rows in the selection. |
Insert column | Inserts a column from one table to another table. For
destination table: For source table:
|
Insert row | Inserts a row into the table.
|
Join | See Using Join action. Use the Join type output examples to help you decide whether to use the
Join or
Merge
action. Note: If you built a bot using this action from
package version 2.0.0-20200624-042148
or earlier, the action will be missing
when you open the bot with the default
package version. You must reinsert
the action and repopulate the
fields. |
Merge | See Using the Merge action. Use the
Merge output example to help you
decide whether to use the Join or
Merge
action. Note: If you built a bot using this action from
package version 2.0.0-20200624-042148
or earlier, the action will be missing
when you open the bot with the default
package version. You must reinsert
the action and repopulate the
fields. |
Remove duplicate rows | Deletes duplicate rows (if any exist). Select the Table variable name from the drop-down list. |
Search for a value | Searches for a specific value in the table, returns the row and
column numbers in which the value occurs, and assigns the row and
column numbers to a List variable. For example, if you search for
the value abc that is available at the fourth row and
third column of a table variable, the action returns 3,2
as output. As the index number for the row and column starts with zero,
the values in the output indicates the fourth row and third column.
|
Set cell value | Updates the value of a specific cell.
|
Sort | Sorts the table data by a column. This action enables you to sort the data by column data format (string, number, datetime, or Boolean).
Note: If you built a bot using this action from
package version 2.0.0-20200624-042148
or earlier, the action will be missing
when you open the bot with the default
package version. You must reinsert
the action and repopulate the
fields. |
Write to file | See Using Write to file action. |