DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations
Building Scalable Real-Time Apps with AstraDB and Vaadin
Register Now

Trending

  • Integration Architecture Guiding Principles, A Reference
  • Fun Is the Glue That Makes Everything Stick, Also the OCP
  • WireMock: The Ridiculously Easy Way (For Spring Microservices)
  • Integration Testing Tutorial: A Comprehensive Guide With Examples And Best Practices

Trending

  • Integration Architecture Guiding Principles, A Reference
  • Fun Is the Glue That Makes Everything Stick, Also the OCP
  • WireMock: The Ridiculously Easy Way (For Spring Microservices)
  • Integration Testing Tutorial: A Comprehensive Guide With Examples And Best Practices
  1. DZone
  2. Data Engineering
  3. Databases
  4. How to Build Pivot Tables

How to Build Pivot Tables

To pivot or not to pivot, that is the question.

Maarit Widmann user avatar by
Maarit Widmann
·
Mar. 08, 19 · Tutorial
Like (2)
Save
Tweet
Share
5.62K Views

Join the DZone community and get the full member experience.

Join For Free

Did you know that a pivot table allows you to quickly summarize your data based on a group, pivot, and aggregation columns? This summary might include sums, averages, or other statistics, which the pivot table splits the statistics is a meaningful way for different subgroups and draws attention to useful information.

How to build a pivot table in KNIME Analytics Platform

Fig. 1: A pivot table showing the average sunshine hours for each city in each month. This table was constructed by applying the pivoting function to a dataset that contains at least one column for month (group column), one column for city (pivot), and one column for sunshine hours (aggregation column).

Would you like to know more about how to use the Pivoting node in KNIME Analytics Platform? This vlog features three videos showing you how to use the Pivoting node, how to apply basic aggregation methods, such as sum and count, statistical aggregation methods, and the aggregation methods available for columns of type Date&Time. We also how to apply multiple aggregation methods to one or more aggregation columns.

So, settle down in your chair and get started with the Pivoting Trilogy, starring the Pivoting node.

The Pivoting Node

The video below shows you how to build a pivot table that summarizes data using the Pivoting node. We explain the elements of a pivot table, i.e. groups, pivots, the aggregation method, and aggregation column and show how to make these settings in the configuration dialog of the Pivoting node.

Pivoting With Complex Aggregation Methods

This next video shows some advanced layouts of the pivot table using multiple aggregation columns, statistical aggregation methods, and aggregations to columns of type Date&Time. We show you how to apply multiple aggregation methods in the same pivot table, discuss aggregation methods for columns of the type Date&Time; we introduce a new aggregation method: Date range(day), and also the aggregation methods, mean, standard deviation and other statistical measures. Finally, we show that some aggregation methods automatically disable the option to include missing values.


Pivoting With Multiple Columns

The last video shows some advanced layouts of the pivot table with multiple pivoting and/or grouping columns and how to set the Pivoting node in order to achieve them. We also introduce the new Mode and (Unique) concatenate aggregation methods.


Further Resources

  • What’s data aggregation? An explanation is available on this video.
  • Examples for using the Pivoting node EXAMPLES Server: 02_ETL_Data_Manipulation/02_Aggregations/09_Examples_for_Using_the_Pivoting_Node
  • Pivoting in Databases EXAMPLES Server: 01_Data_Access/02_Databases/05_Pivoting_in_Databases
Database Pivot table Build (game engine)

Published at DZone with permission of Maarit Widmann, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Trending

  • Integration Architecture Guiding Principles, A Reference
  • Fun Is the Glue That Makes Everything Stick, Also the OCP
  • WireMock: The Ridiculously Easy Way (For Spring Microservices)
  • Integration Testing Tutorial: A Comprehensive Guide With Examples And Best Practices

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com

Let's be friends: