Home > Data Cleaning > Aggregate
Operators
| Operator | Description |
|---|---|
| Aggregate | Calculate different types of aggregation values |
Total: 1 operator
This is the multi-page printable view of this section. Click here to print.
Home > Data Cleaning > Aggregate
| Operator | Description |
|---|---|
| Aggregate | Calculate different types of aggregation values |
Total: 1 operator
Home > Data Cleaning > Aggregate
| Property | Requirement | Type | Default | Description |
|---|---|---|---|---|
| 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 Keys | List | - | Group by columns |
Counting rows: with the
countfunction, 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.
| Port | Mode |
|---|---|
| 0 | Set Snapshot |