August 17, 2023

tAggregateSortedRow – Docs for ESB 5.x



tAggregateSortedRow properties

Component family




tAggregateSortedRow receives a
sorted flow and aggregates it based on one or more columns. For each
output line, are provided the aggregation key and the relevant
result of set operations (min, max, sum…).


Helps to provide a set of metrics based on values or calculations.
As the input flow is meant to be sorted already, the performance are
hence greatly optimized.

Basic settings

Schema and Edit

A schema is a row description, it defines the number of fields to
be processed and passed on to the next component. The schema is
either Built-in or stored remotely
in the Repository.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

Click Edit schema to make changes to the schema. If the
current schema is of the Repository type, three options are

  • View schema: choose this option to view the
    schema only.

  • Change to built-in property: choose this option
    to change the schema to Built-in for local

  • Update repository connection: choose this option to change
    the schema stored in the repository and decide whether to propagate the changes to
    all the Jobs upon completion. If you just want to propagate the changes to the
    current Job, you can select No upon completion and
    choose this schema metadata again in the [Repository

Click Sync columns to retrieve
the schema from the previous component connected in the Job.

This component offers the advantage of the dynamic schema feature. This allows you to
retrieve unknown columns from source files or to copy batches of columns from a source
without mapping each column individually. For further information about dynamic schemas,
see Talend Studio
User Guide.

This dynamic schema feature is designed for the purpose of retrieving unknown columns
of a table and is recommended to be used for this purpose only; it is not recommended
for the use of creating tables.



Built-in: The schema will be
created and stored locally for this component only. Related topic:
see Talend Studio User Guide.



Repository: The schema already
exists and is stored in the Repository, hence can be reused in
various projects and Job flowcharts. Related topic: see
Talend Studio User


Input rows count

Specify the number of rows that are sent to the tAggregateSortedRow component.


If you specified a Limit for
the number of rows to be processed in the input component, you
will have to use that same limit in the Input rows count field.


Group by

Define the aggregation sets, the values of which will be used for



Output Column: Select the column
label in the list offered based on the schema structure you defined.
You can add as many output columns as you wish to make more precise

Ex: Select Country to calculate an average of values for each
country of a list or select Country and Region if you want to
compare one country’s regions with another country’ regions.



Input Column: Match the input
column label with your output columns, in case the output label of
the aggregation set needs to be different.



Select the type of operation along with the value to use for the
calculation and the output field.



Output Column: Select the
destination field in the list.



Function: Select the operator
among: count, min, max, avg, first, last.



Input column: Select the input
column from which the values are taken to be aggregated.



Ignore null values: Select the
check boxes corresponding to the names of the columns for which you
want the NULL value to be ignored.

Advanced settings

tStatCatcher Statistics

Check this box to collect the log data at component level.

Global Variables

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

NB_LINE: the number of rows read by an input component or
transferred to an output component. This is an After variable and it returns an

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio
User Guide.


This component handles flow of data therefore it requires input
and output, hence is defined as an intermediary step.


The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User

For more information on the log4j logging levels, see the Apache documentation at



Related scenario

For related use case, see Scenario 1: Aggregating values
and sorting data

Document get from Talend
Thank you for watching.
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x