Filter rows in Table¶
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.
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.
- Table1 : Table
Table with column, C0, with reference values.
- Table2 : Table
Table with column, C1.
- FilteredTable : Table
Table with the rows that satisfied the comparison relation between C0 and C1.
- 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.