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 actions are missing when you open the bot with the default package version, ensure that you reinsert the actions and repopulate the fields.

Action Description
Assign Assign action in the Data Table package.
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