Stories
Live tasks
Bricks
Login
Back to bricks list
Introduction Version

Table row data text filter

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

Filters the table rows based on values of one or multiple columns with text 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 : =, !=, contains, contains not, startwith and endswith.

If you need to apply filters on text values, you can use the Table row data numeric filter task.

Input

Table
2d excel like table
Table

Output

Table
2d excel like table
Table

Configuration

text_filter

Type : ListMaximum occurrences number : 9

column_name_regex

Optional

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

Type : string

comparator

Comparator

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

value

Value

Type : string

stringify_table

Optional

If true convert all the value (including numeric) to text. Otherwise none text value are ignored.

Type : bool