Configure tAggregateRow.
Procedure
-
Double-click tAggregateRow to open its
Components view.
-
Click the
button next to Edit schema
to open the schema dialog box, and define the schema. In this scenario, add one
output column named totalNbPassengers.
When done, click OK to save the changes and close the
schema dialog box.
-
Add one row in the Operations table and define the
operation to be carried out. In this scenario, the operation is sum. Then
select nbPassengers from the drop-down list in the Input
column position column to aggregate the input data based on
it.
Results
The
tAggregateRow component is
configured to calculate the total number of passengers flying from Paris.