Table row data numeric filter
Filters the table rows based on values of one or multiple columns with numeric comparator
For earch filters, the system will keep the rows where the value in the column provided by the parameter Column name
validated condition (the comparator
with the value
parameter).The result table will have the same number of columns as the input table.
The Column name
supports pattern. This means that multiple columns can be used in the filter. In this
case all the values in the provided columns must validate the condition. You can set the value *
in the Column name
which mean that all the values in the row must validate the condition.
Supported operators : =
, !=
, >=
, <=
, >
and <
If you need to apply filters on text values, you can use the Table row data text filter
task.
Input
Output
Configuration
numeric_filter
List
9
column_name_regex
The name of the columns along which the filter is applied (regexp pattern); Use '*' for all the columns
string
comparator
Comparator
string
=
!=
>=
<=
>
<
value
Value
float