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

The Data Table package includes the following actions:

Note: If you built a bot using actions from the Data Table package from Build 5322 or earlier, the actions will be missing when you open the bot with the default package version. You must reinsert the actions and repopulate the fields.


Action	Description
Assign	Assign action.
Change column type	Change column type action.
Clear content	Clear content action.
Delete column	Delete column action.
Delete row	Delete row action.
Get number of columns	Get number of columns action.
Get number of rows	Get number of rows action.
Insert column	Insert column action.
Insert row	Insert row action.
Join	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	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	Remove duplicate rows action.
Search for a value	Search for a value action.
Set value of a single cell	Set value of a single cell action.
Sort	Sort action.
Write to file	Using Write to file action.

Example: Example of extracting data from a web table

Automation 360