Filter Rows Transform
|Transform Icon||Transform Description|
|The Filter Rows Transform is used to filter rows from an upstream based on an expression.|
|Column Browser||Located in the top left, the column browser show all available columns, variable and connections that can be used as part of a derived column expression.|
|Functions Browser||Located in the top right, the functions browser lists all of the available functions that can be used in the advanced derived column.|
|Filter Grid||The filter grid allows you to define a single expression to filter rows matching the expression.|
- Name - This is the name of the output where any rows that do not match any of the expressions are routed.
- Expression - This is the expression used to filter the rows of data.
|Validate All||The Validate All button evaluates all of the expressions and checks if the expression has errors. An error or warning icon displays if there are any issues with the expressions.|
|Test Expression||This button creates temporary values based on the data type and executes the expression that is currently selected in the grid.|
Available Functions List
For a list of all available functions, along with syntax, descriptions, and examples, see the Functions List articles.