Action group: Tables
This action is intended to retrieve data from the specified table column.
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Data table | Table for which the action will be performed. | Robin.DataTable | Yes | |
| Column name | Name of the column from which the data will be retrieved. If the field is not filled, then the value from the «Column index» field is taken. | Robin.String | No | |
| Column index | Index of the column from which the data will be retrieved. Indexing starts at 0. If the «Column name» field is filled in, the value in the «Column index» field is ignored. Default value is «0». | Robin.Numeric | No | |
| Results | ||||
| Result | The variable in which the received data will be stored. | Robin.Collection | ||
The syntax of the applied functions can be examined by the example of the following table,
The INDEX parameter searches for data in the range at the intersection of the specified row and column/column, returning the result to a predesignated cell. The sheet coordinates are specified for the array.
It has the following syntax: =INDEX(array;column_number).
The column number does not mean the number on the sheet coordinates, but the order within the specified array itself
INDEX(array;column_number)
Array is a reference to a range of cells.
Column_number - the number of the column in the array from which you want to return a value.
The values of the "column_number" arguments must point to a column within the specified array; otherwise, the INDEX() function will return an error.
None.
There is a table in CSV format.
It is necessary to get data from the BINDING column.
Use "Get table from CSV", "Get column data" actions.
The program robot completed successfully.
The data from the column has been retrieved.
