Documentation forTask Factory

Task Factory Filter Rows Transform

 Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.

Filter Rows Transform

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

Task Factory Filter Rows Transform

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.