Task Factory Filter Rows Transform

Filter Rows Transform

Transform Icon	Transform Description
	The Filter Rows Transform is used to filter rows from an upstream based on an expression.

Option	Description
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.