Task Factory Advanced Aggregator 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.

Advanced Aggregator Transform

Transform IconTransform Description
Task Factory Advanced Aggregator Transform IconThe Advanced Aggregator Transform is used to aggregate rows of data from an upstream based on grouping.

General Tab

Task Factory Advanced Aggregator Transform

Column Browser

Task Factory Advanced Aggregator Transform Column Browser window

Located 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 each plus sign next to a 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 Browser

Task Factory Advanced Aggregator Transform Functions Browswer window

Located 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 List

For a list of all available functions, along with syntax, descriptions, and examples, see the Functions List articles.

Columns Grid

Task Factory Advanced Aggregator Transform General Columns Grid

The Columns Grid (the bottom window) allows you to create expressions used for aggregation and variable expressions.

NameThe name of the column or expression.
ActionThe action this column performs.

  • Variable Expression - This option creates a reusable expression that can be used in the expression column of the current column or other columns in the grid.
  • Add As New Column - This creates a new derived column based on the expression.
ExpressionThis is the expression used to perform the action from the action column.
Data TypeThe data type for the current column.
LengthThe length of the current column.
PrecisionThe precision of the current column.
ScaleThe scale of the current column.
CodePageThe code page of the current column.
Group ByDetermines whether the expression is used in the group by calculation.

Advanced Tab

Task Factory Advanced Aggregator Transform Advanced

On TruncationAction to take when a truncation occurs.
On ErrorAction to take when an error occurs.
Max Errors to IgnoreHow any errors to ignore before failing component.
Max WarningsMaximum number of warnings you want to show in the execution log when you have errors or data truncation.

Validate All Button

The Validate All button evaluates all of the expressions and checks if they have errors. An error or warning icon appears if there are any issues with the expressions.

Test Expression (Using Placeholder Values) Button

This button creates temporary values based on the data type and execute the expression that is currently selected in the grid. 

Note:  To test the expression by entering your own values, use the expression editor.