Filter data

A group of actions: None

The action filters the data in the specified table and returns a new table with the filtered data

Settings

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for ods/xlsx document	Robin.OpenSheetD oc		Yes
Column name	The name of the column by which the table will be filtered. If the field is empty, then the value is taken from the «Column index» field	Robin.String		No
Column index	Index of the column by which the table will be filtered. Indexing starts at 0. If the Column Name field is filled in, then the value in the Column Index field is ignored. The default value is «0»	Robin.Numeric		No
Criterion	The filtering criterion. Filled in the format «=value», «<value», «>value», «>=value», «<=value», or «<>value». If the field value is not filled, then the filtering will be set by the value «(Empty)»	Robin.String		No
Results
Filtered table	Table after filtering	Robin.DataTable