Filter rows in Tables

../../../../_images/filter.svg

Filter the row in a table according to a comparison relation between the elements of two column. One of the column, C1, is located in the Table that will be filtered while the other, C0, is a column in a reference Table.

The comparison relation can defined as a lambda function in the configuration GUI by the user or one of the predefined relations can be used.

The predefined relations are the following:
  • Match C1 in C0

    keeps the row if the corresponding element in C1 exists in any row in C0.

  • Don’t match C1 in C0

    keeps the row if corresponding element in C1 do not exist in any row in C0.

class node_table_filter.ColumnFilterTables[source]

Filter rows in Table. The filtration will be performed according to a specified/selected comparison relation between the elements of a column in the considered Table and the elements of a column in a reference Table.

Inputs:
Table1
: Table

Table with column, C0, with reference values.

Table2
: Table

Table with column, C1.

Outputs:
FilteredTable
: Table

Table with the rows that satisfied the comparison relation between C0 and C1.

Configuration:
Select C0 column

Select a column in Table1 to use as reference column C0.

Select C1 column

Select a column in Table2 to use as object column C1.

Select filter function

Select predefined filter function.

Use custom filter function

Turn on/off use of custom filter

Filter function

Write custom filter, must be a lambda function.

Preview
: button

When pressed the results of selected settings are displayed in the preview window below the button.

Ref. nodes:

Select rows in Table