| 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.
|
| 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 execution of the bot is completed,
the original values of the table variables are restored.It enables
you to reuse an existing table variable to store values that are used
only during the execution of the bot. 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.
- 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.
- 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.
- Select the Table variable name from
the drop-down list.
- Select where to insert the row: first index, last index,
or enter the row index number.
Note: The index count starts 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. |
| Merge |
See Using Merge action. Use the
Merge output example to help you
decide whether to use the Join or
Merge
action. |
| 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 numeric and text data.
- 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.
|
| Write to file |
See Using Write to file action. |