Hub
Pricing About
NodeNode / Manipulator

DB Pivot

DBQuery
Drag & drop
Like

This node pivots the input DB Data table using the selected 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.

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

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2026 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits