Login
Back to bricks list
Introduction Version

Table column data text filter

TRANSFORMER
Typing name :  TASK.gws_core.TableColumnDataTextFilter Brick :  gws_core

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

Type : ListMaximum occurrences number : 9

row_name_regex

Optional

The name of the rows along which the filter is applied (regexp pattern); Use '*' for all the rows

Type : string

comparator

Comparator

Type : stringAllowed values : =  !=  contains  contains notstartswith  endswith 

value

Value

Type : string