Filter Version 4 (Net)

Action group: Tables

Description

This action is intended to filter the table by the value of the specified 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 by which the table will be filtered. If the field is not filled, then the value from the «Column index» field is taken.Robin.String
No
Column indexIndex of the column by which the table will be filtered. 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
CriteriaFiltration criterion. Filled in the format «=value», «<value», «>value», «>=value», «<=value», «<>value». If the field value is not filled in, filtering will be set by the value «(Empty)».Robin.String
No

Special conditions of use

None.

Example of use 

Task

There is a CSV table.

 .

You need to filter the values in column A by the >500 condition. 

Solution

Use "Get table from CSV", "Filter" actions.

Implementation

  1. Assemble a robot scheme with the actions:

  2. Set the "Get table from CSV" action parameters.

  3. Set the "Filter" action parameters.
  4. Click "Start" in the top panel.

Result

The program robot completed successfully.

The data is filtered.