Icon

09_​Examples_​for_​Using_​the_​Pivoting_​Node

Basic and Advanced Usage of the Pivoting Node

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.

Pivoting examplesFor more information see the workflow metadata. Find it here: View -> Description Basic example: a pivot table with one group and one pivotcolumnQuestion: How many male/female customers belong to each age bin?Group: Age BinPivot: GenderAggregation Column: CustomerKey or any otherAggregation Operator: Count Two pivot columnsQuestion: What is the most common product among customers accordingto their sentiment, gender and marital status?Group: Sentiment AnalysisPivot: MaritalStatus, GenderAggregation Column: ProductAggregation Operator: Mode Two group columnsQuestion: Which web activity classes are represented in groups accordingto marital status, gender and sentiment?Group: MaritalStatus, GenderPivot: Sentiment AnalysisAggregation Column: WebActivityAggregation Operator: Unique concatenate Aggregation Column of Type Date and TimeQuestion: What is the age dispersion of the customers according todifferent product and sentiment groups? Group: ProductPivot: Sentiment AnalysisAggregation Column: birthdayAggregation Operator: Date range(day) Two aggregation operatorsQuestion: What is the mean and standard deviation of income according todifferent sentiment and gender groups?Group: Sentiment AnalysisPivot: GenderAggregation Column: EstimatedYearlyIncomeAggregation Operator: Mean, Standard deviation Customer dataCount of customersCustomer dataMode of productCustomer dataUnique concatenate of web activity classesCustomer dataCustomer dataDate range(day)of birthdaysMean and standarddeviation of income Table Reader Pivoting Table Reader Pivoting Table Reader Pivoting Table Reader Table Reader Pivoting Pivoting Pivoting examplesFor more information see the workflow metadata. Find it here: View -> Description Basic example: a pivot table with one group and one pivotcolumnQuestion: How many male/female customers belong to each age bin?Group: Age BinPivot: GenderAggregation Column: CustomerKey or any otherAggregation Operator: Count Two pivot columnsQuestion: What is the most common product among customers accordingto their sentiment, gender and marital status?Group: Sentiment AnalysisPivot: MaritalStatus, GenderAggregation Column: ProductAggregation Operator: Mode Two group columnsQuestion: Which web activity classes are represented in groups accordingto marital status, gender and sentiment?Group: MaritalStatus, GenderPivot: Sentiment AnalysisAggregation Column: WebActivityAggregation Operator: Unique concatenate Aggregation Column of Type Date and TimeQuestion: What is the age dispersion of the customers according todifferent product and sentiment groups? Group: ProductPivot: Sentiment AnalysisAggregation Column: birthdayAggregation Operator: Date range(day) Two aggregation operatorsQuestion: What is the mean and standard deviation of income according todifferent sentiment and gender groups?Group: Sentiment AnalysisPivot: GenderAggregation Column: EstimatedYearlyIncomeAggregation Operator: Mean, Standard deviation Customer dataCount of customersCustomer dataMode of productCustomer dataUnique concatenate of web activity classesCustomer dataCustomer dataDate range(day)of birthdaysMean and standarddeviation of income Table Reader Pivoting Table Reader Pivoting Table Reader Pivoting Table Reader Table Reader Pivoting Pivoting

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Ferry
Created at: 2016-04-19
On NodePit since: 2025-02-18
Last update: 2026-07-17
Created with KNIME version: v4.1.1
Tags: ETLdata aggregationpivotinggroupingdata transformationdata preprocessingsummarizing dataorganizing data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!