Filter rows in Tables

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

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