Hub
Pricing About
NodeNode / Manipulator

Unpivot

ManipulationRowTransform
Drag & drop
Like

This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row. Example:

Input:
	Value1 Value2 Value3 Extra1 Extra2 Extra3
Output:
	Value1 Extra1 Extra2 Extra3
	Value2 Extra1 Extra2 Extra3
	Value3 Extra1 Extra2 Extra3
			

Node details

Input ports
  1. Type: Table
    Data table
    Input table with at least one value column for the unpivoting operation.
Output ports
  1. Type: Table
    Unpivoting table
    Unpivoting table with duplicated columns together with rotated value columns and their corresponding column names.

Extension

The Unpivot node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

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
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits