Research documentation

Getting Started

Developer guide

Tutorials

Release

Technical Documentation

Resources

Tasks

Base env shell task

Conda env live task

Conda env shell

Create a sugar type of food

Dataset exporter

Dataset importer

Download resource from a S3 bucket

Download resource from external source

Encoded table exporter

Encoded table importer

EncodingTable exporter

EncodingTable importer

Fs node extractor

JSON Dict exporter

JSON Dict importer

Mamba env live task

MetadataTable exporter

MetadataTable importer

Pip env live task

Python live task

R conda env live task

R mamba env live task

Resource exporter

Resource importer

Resource picker

Resource set exporter

Resource stacker

Smart interactive plot generator

Smart json transformer

Smart plot generator

Smart table transformer

Table aggregator

Table aggregator filter

Table annotator

Table column aggregator

Table column aggregator filter

Table column annotator

Table column concat

Table column data numeric filter

Table column data text filter

Table column operation mass

Table column operations

Table column scaler

Table column tag aggregator

Table column tag extractor

Table column tag unfolder

Table column tags deleter

Table column tags selector

Table columns deleter

Table columns selector

Table row aggregator

Table row aggregator filter

Table row annotator

Table row concat

Table row data numeric filter

Table row data text filter

Table row scaler

Table row tag aggregator

Table row tag extractor

Table row tag unfolder

Table row tags deleter

Table row tags selector

Table rows deleter

Table rows selector

Table to dataset converter

Table transposer

The travel of `Astro`

Uncompress file

Upload resource to S3

Protocols

Table row data text filter

TRANSFORMER

Typing name : TASK.gws_core.TableRowDataTextFilter

Brick : gws_core v

Parent :

Transformer v.0.5.15

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

Output

Table

2d excel like table

Configuration

text_filter

Type : List

Maximum 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 : string

Allowed 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