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	Assigns values to a table variable. You can use this action to manually enter the table data. Select whether to create a table with or without values. If you select to create a table with values, either manually enter the values or select a source table variable. If you select to create a table without values, specify the number of rows and columns. Select a table variable to hold the output. You can either select the source table variable to overwrite the values, or select a different table variable.
Change column type	Changes the data type of a column. Select the Data table name from the drop-down list. Select whether to specify the column by Name or Index. If you select to specify by name, enter the column name. If you select to specify by index, enter the column index. For example, to set a value to the first column, enter `0`. Select the new column data type from the drop-down list to to Number, Boolean, String, or Datetime. If you select Datetime, you can format the values by selecting a predefined format or specifying a custom format. To specify the format applied on the input data table variable, select an option either from the predefined format list or enter the value in a custom format. Select a table variable to include the output. You can either select the source table variable to overwrite the values or select a different table variable.
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. Select the Table variable name from the drop-down list. Specify the column name or column index to delete. Note: The index count starts from 0.
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. Select the Table variable name from the drop-down list. Specify the row name or row index to delete. Note: The index count starts from 0.
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: Select the destination table variable form the Enter into data table list. Select where to insert the column: first index, last index, or enter the column index number. Note: The index count starts from 0. For source table: Select the source table variable from the Insert from table list. Enter the name or index number of the column to insert.
Insert row	Inserts a row into the table. In the Data table name field, select the name of the table variable from the drop-down list or create a new variable of type Table. Select where you want to insert the row: first position, last position or at a specific index position. In the Row record name field, create a record variable or choose an existing record variable to hold the values for the new row that you want to insert. In the Create variable tab, enter the name of the variable and under the Default value section, enter the name, value, and the type of value that you want to add to the new row as per the specified index values. Note: The index count start from 0.
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. Select the Table variable name from the drop-down list. Enter the value to search for. Select Match case to ensure the case matches the value searched.
Set cell value	Updates the value of a specific cell. Select the Table variable name from the drop-down list. Enter the row index. For example, to set a value to the first row, enter `0`. Select whether to specify the column by Name or Index. If you select to specify by name, enter the column name. Capitalization is not important. If you select to specify by index, enter the column index. For example, to set a value to the first column, enter `0`. Enter the value to set.
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). Select the Table variable name from the drop-down list. Specify the column name or column index to sort by. Select the order in which to sort: ascending or descending. 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.

Example: Example of extracting data from a web table

Automation 360