This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Aggregate

Operators in the Aggregate category

Home > Data Cleaning > Aggregate

Operators

OperatorDescription
AggregateCalculate different types of aggregation values

Total: 1 operator

1 - Aggregate

Calculate different types of aggregation values

Home > Data Cleaning > Aggregate

Input Properties

PropertyRequirementTypeDefaultDescription
Aggregations✓List-Multiple aggregation functions (min: 1,
aggregations cannot be empty)
↳ Aggregate Func✓sum, count, average, min, max, concat-Sum, count, average, min, max, or concat
↳ Attribute✓ (optional for count)String-Column to aggregate on. Required for every function except count: leave it empty with count to count all rows (COUNT(*)), or pick a column to count its non-null values
↳ Result Attribute✓String-Column name of the aggregation result
Group By KeysList-Group by columns

Counting rows: with the count function, leave Attribute empty to count every row (COUNT(*), including rows with nulls), or choose a column to count only that column’s non-null values.

Output Ports

PortMode
0Set Snapshot