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 IconTransform Description
Task Factory Filter Rows Transform IconThe Filter Rows Transform is used to filter rows from an upstream based on an expression.

Task Factory Filter Rows Transform

Column BrowserLocated 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 BrowserLocated in the top right, the functions browser lists all of the available functions that can be used in the advanced derived column.
Filter GridThe 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 AllThe 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 ExpressionThis 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.