Get column data Version 3 (Net)

Action group: Tables 

Description

This action is intended to retrieve data from the specified table column.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Data tableTable for which the action will be performed.Robin.DataTable
Yes
Column nameName 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 indexIndex 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
ResultThe 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.

Special conditions of use

None.

Example of use 

Task

There is a table  in CSV format.

It is necessary to get data from the BINDING column.  

Solution

Use "Get table from CSV", "Get column data" actions.

Implementation

  1. Assemble a robot consisting of actions:
  2. Set the parameters for the "Get table from CSV" action.
  3. Set the parameters for the "Get column data" action.


  4. Click "Start" in the top panel.

Result

The program robot completed successfully.

The data from the column has been retrieved. 

  • Нет меток