August 15, 2023

Calculating the average – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Calculating the average – Docs for ESB 6.x

Calculating the average

  1. Double-click tAggregateRow to open its
    Component view.

    use_case-mr_tglobalvarload4.png

  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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x