Use an aggregate field to define aggregate calculations.
When you configure an Aggregator transformation, create an aggregate field for the output of each calculation that you want to use in the data flow. You can use aggregate functions in aggregate fields. You can also use conditional clauses and nonaggregate functions.
Configure aggregate fields on the
tab of the
panel. When you configure an aggregate field, you define the field name, data type, precision, scale, and optional description. The description can contain up to 4000 characters. You also define the calculations that you want to perform.
When you configure aggregate fields, you can use variable fields for calculations that you want to use within the transformation. You can also include macros in aggregate and variable fields.
In advanced mode, the output is NULL if the Group by field returns a single row and the aggregate expression contains the STDDEV and VARIANCE functions. This is because
uses Spark 3.2. To get an output value of 0, set the