Create a pivot table with one or more group columns and one or more pivot columns. Apply basic aggregation methods like sum and count, statistical aggregation methods, and aggregation methods available for columns of type Date&Time. Apply multiple aggregation methods to one or more aggregation columns.
Resources
EXAMPLES Server: 02_ETL_Data_Manipulation/02_Aggregations/09_Examples_for_Using_the_Pivoting_Node02_ETL_Data_Manipulation/02_Aggregations/09_Examples_for_Using_the_Pivoting_Node*
Download a zip-archive
Video:
- The Pivoting Node: Basic Examples
- The Pivoting Node: Advanced Examples I
- The Pivoting Node: Advanced Examples II
* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually