Aggregation functions - Cloud

Talend Data Shaping Language Reference Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Data Shaping Language
Content
Design and Development

Aggregation functions are usually used with a GROUP BY clause, but they can also be used in standard FROM-WHERE-SELECT clauses.

Function Description Arguments
avg Calculates the average of a group or collection of values. Numeric value or identifier/path to a numeric element in a collection.
count Returns the number of values in a group or collection. Numeric value or identifier/path to a numeric element in a collection.
min Returns the smallest value in a group or collection. Numeric value or identifier/path to a numeric element in a collection.
max Returns the largest value in a group or collection. Numeric value or identifier/path to a numeric element in a collection.
sum Returns the sum of all the values in a group or collection. Numeric value or identifier/path to a numeric element in a collection.