Skip to main content Skip to complementary content

Calculating the average

Procedure

  1. Double-click tAggregateRow to open its Component view.
  2. Click the [...] button next to Edit schema to open the schema editor.
  3. In the table of the tAggregateRow schema, click the [+] button once to add one row and in the Column column, rename it to avg.
  4. In the Type column of the salary row, select Double.
  5. Click OK to validate these changes and accept the propagation prompted by the pop-up dialog box.
  6. Under the Operations table, click the [+] button to add one row and configure the following columns of this row to define the calculation of the average salary.

    Column

    Description

    Output column

    Select the column of the output schema in which the average salary is stored. In this scenario, it is avg.

    Function

    Select the avg function to calculate the average.

    Input column position

    Select the column of the input schema used to provide the source data of the calculation.

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!

Leave your feedback here