This node allows to filter rows based on a query defined in the node dialog. A query can contain conditions on multiple columns, which can be grouped and combined with either the logical AND or logical OR operation.
The row filter also allows to apply conditions to the RowID as well as index based conditions. The corresponding columns are called <RowID> and <RowINDEX> and are always the top most options when opening the drop down for column selection. The <RowID> is treated as a string column, while the <RowINDEX> is considered to be numerical starting at index 0.
- Type: TableTo be filteredData table from which to filter rows.