Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Pivot
NodeNode / Manipulator

DB Pivot

DB Query
Drag & drop
Like
Copy short link

This node pivots the input DB Data table using the selected of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns for each unique set of column combinations together with each aggregation method.

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: DB Data
    DB Data
    DB Data to apply pivoting.
Output ports
  1. Type: DB Data
    Pivoted DB Data
    DB Data with pivoted rows.

Extension

The DB Pivot node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Database Pivot
    Database Pivoting
    This workflow creates an SQL statement that generates a pivot table. A pivot table allows…
    knime > Examples > 01_Data_Access > 02_Databases > 05_Pivoting_in_Databases
    knime
  2. Go to item
    Database Pivot
    Database Pivoting
    This workflow creates an SQL statement that generates a pivot table. A pivot table allows…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 05_Pivoting_in_Databases
    knime
  3. Go to item
    Database Pivot
    Database Pivoting
    This workflow creates an SQL statement that generates a pivot table. A pivot table allows…
    haoran > Public > 01_Data_Access > 02_Databases > 05_Pivoting_in_Databases
    haoran
  4. Go to item
    01_Data Access and Transformation
    knime > Education > Courses > L4-CA Machine Learning for Chemical Applications > Exercises > 01_Data Access and Transformation
    knime
  5. Go to item
    01_Data Access and Transformation
    knime > Education > Courses > L4-CA Machine Learning for Chemical Applications > Solutions > 01_Data Access and Transformation
    knime
  6. Go to item
    DB_practice_v01
    khs > Public > DB_practice_v01
    khs
  7. Go to item
    Providing an Interactive Data App with KNIME and Snowflake
    Snowflake Customer Intelligence CI
    +5
    This workflow is an example of how to turn Snowflake data into an interactive Data App th…
    knime > Examples > 40_Partners > 07_Snowflake > 04_Snowflake_Dynamic_Data_App
    knime
  1. Go to item
  2. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits