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

Unpivot

Manipulation Row Transform
Drag & drop
Like
Copy short link

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
  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
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