Skip to main content Skip to complementary content

Aggregating the Avro messages

Configure tAggregateRow.

Procedure

  1. Double-click tAggregateRow to open its Components view.
  2. 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.
  3. 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!