Filter data Version 1 (Python)

Action group: Office

Description

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

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

None.

There is a file Book1.xlsx with data.

It is necessary to filter the data according to the condition: number>6 in column A, save the document.

Use the actions "Open", "Filter data", "Save", "Close".

Assemble a robot scheme consisting of actions:
Set the parameter for the "Open" action (specify the file path).
Set parameters for the "Filter data" action.
In the "Context" field specify the context created in step 1
In the "Column name" field specify the value = A.
In the "Criterion" field, specify the expression >6.
In the "Result" field specify the variable "Table", having created it in advance.
Set the parameter for the "Save" action.
5. Click on the "Start" button in the top panel.