Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Pivoting
NodeNode / Manipulator

Pivoting

Manipulation Row Transform
Drag & drop
Like
Copy short link

Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns for each set of column combinations together with each aggregation method. In addition, the node returns the total aggregation (a) based on only the group columns and (b) based on only the pivoted columns resulting in a single row; optionally, with the total aggregation without pivoting.

To change the aggregation method of more than one column select all columns to change, open the context menu with a right mouse click and select the aggregation method to use.

A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.

Node details

Input ports
  1. Type: Table
    Data table
    The input table to pivot.
Output ports
  1. Type: Table
    Pivot table
    Pivot table.
  2. Type: Table
    Group totals
    A table containing the totals for each defined group. That is, the aggregation for each group ignoring the pivoting groups. This table can be joined with the Pivot table; the RowIDs of both tables represent the same groups). The table will contain as many rows as there are different groups in the data and as many columns as there are selected aggregations. The table is identical to the output of a GroupBy node, in which the group and aggregation columns are chosen accordingly.
  3. Type: Table
    Pivot totals
    A single row table containing the aggregated values of the Pivot table. The table structure is identical to the Pivot table (possibly enriched by overall totals if the "Append overall totals" is selected. This table is usually concatenated with table that results from joining the Pivot table with the Group table.

Extension

The Pivoting node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Data transforming - vertical to horizontal
    bruno29a > Public > Forum > Data transforming - vertical to horizontal
  2. Go to item
    Rows to columns
    Rows to columns using Pivoting Request: This is my input: Number Letter Number3 1111111 A…
    bruno29a > Public > Forum > Rows to columns
  3. Go to item
    Pivoting Example
    data_coach > KNIME Foundations > 3 - Manipulating Data > 8 - Pivoting > Pivoting Example
  4. Go to item
    Lab 3 - 06 - Aggregations
    the32bitphoenix > Public > Lab 3 - Additional Examples > Lab 3 - 06 - Aggregations
  5. Go to item
    Simple reporting example
    Reporting
    The report shows the distribution of income over the work class. In order to see the repo…
    knime > Examples > 05_Reporting > 01_BIRT > 01_Simple_Example_for_Reporting
  6. Go to item
    Simple reporting example
    Reporting
    The report shows the distribution of income over the work class. In order to see the repo…
    jfigueroa9 > Public > 01_Simple_Example_for_Reporting
  7. Go to item
    Split Numbers vs Strings
    Data Manipulation RegEx
    This workflow demonstates how to split number against string values from same column and …
    ipazin > Public > 2020_08_05_Split_Numbers_vs_Strings
  8. Go to item
    14_Pivoting - Solution
    E-learning Aggregation Group
    +2
    Solution to an e-learning course exercise. Calculate summary statistics for subgroups of …
    stervis > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 14_Pivoting - Solution
  9. Go to item
    12_Pivoting - Solution
    E-learning Aggregation Group
    +2
    Solution to an e-learning course exercise. Calculate summary statistics for subgroups of …
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 12_Pivoting - Solution
  10. Go to item
    Simple reporting example
    Reporting
    The report shows the distribution of income over the work class. In order to see the repo…
    waelrashwan > Public > 01_Simple_Example_for_Reporting2
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits