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