Task Factory Advanced Conditional Split Transform

Advanced Conditional Split Transform

Transform IconTransform Description
Task Factory Advanced Condtional Split Transform IconThe Advanced Conditional Split Transform is used to conditionally route rows to different outputs depending on the expression defined by using columns, variables, and expressions.

Task Factory Advanced Conditional Split Transform

OptionDescription
Column BrowserLocated on the left hand side, the column browser window shows you all the available columns, variables and connections that can be used as part of a derived column expression. Selecting a plus sign next to each group in the tree view expands that group of items. Any item from the column browser can be dragged into an expression in the column grid below.
Functions BrowserLocated on the right hand side, the functions browser window lists all of the available functions that can be used in the advanced derived column (as well as any of the expressions based tasks). All functions are grouped into an appropriate group (e.g. Character, Data Cleansing) based on what the function either does or returns. For instance, the character function Left is listed under the Character group because it performs operations on a set of characters or a string. Selecting a function gives you a description, syntax overview, and examples on how to use the function.
Available Functions ListFor a list of all available functions, along with syntax, descriptions, and examples, see the Functions List articles.
Output GridThe bottom window which is the output grid allows you to define conditional split expressions to route rows matching the expression for that output.
General Tab
  • Name - The name of the column or expression.
  • Expression - This is the expression used to conditionally split the rows of data.
Validate All ButtonThe Validate All button evaluates all of the expressions and check if they have errors. An error or warning icon displays if there are any issues with the expressions.
Test Expression (Using Placeholder Values) ButtonThis button creates temporary values based on the data type and executes the expression that is currently selected in the grid. To test the expression by entering your own values use the expression editor.
Default Output Name
This is the name of the output where any rows that do not match any of the expressions are routed.