Version: v2.4
Cube
Cube Node generates a result set that shows aggregates for all combinations of values in the selected columns.
Type
transform
Fields
Name | Title | Description |
---|---|---|
cubeCols | Cube Columns | |
aggregateCols | Aggregate Columns | Aggregate Columns |
aggregateOperations | Aggregate Operation to Use | Aggregate Operation |
Examples
Input
name | age | height |
---|---|---|
Alice | 5 | 80 |
Alice | 5 | 80 |
Alice | 10 | 80 |
James | 5 | 50 |
James | 10 | 60 |
James | 7 | 80 |
Parameters1
Name | Value |
---|---|
Cube Columns | name |
Id | Aggregate Columns | Aggregate Operation to Use |
---|---|---|
1 | age | max |
2 | height | min |
Output1
name | max_age | min_height |
---|---|---|
Alice | 10 | 80 |
10 | 50 | |
James | 10 | 50 |
Parameters2
Name | Value |
---|---|
Cube Columns | age |
Id | Aggregate Columns | Aggregate Operation to Use |
---|---|---|
1 | height | max |
2 | height | min |
Output2
age | max_height | min_height |
---|---|---|
80 | 50 | |
5 | 80 | 50 |
10 | 80 | 60 |
7 | 80 | 80 |