Hub
NodeNode / Manipulator

Unpivoting

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 on value column for the unpivoting operation.
Output ports
  1. Type: Table
    Unpivoting table
    Unpivoting table with duplicated columns together with one rotated value column and their corresponding column names.

Extension

The Unpivoting node is part of this extension:

Related workflows & nodes

  1. Unpivoting - fredrikt
    elsamuel > Public > Unpivoting - fredirkt > Unpivoting - fredrikt
  2. FlexibleNumberColumnsBIRT
    iris > Public > FlexibleNumberColumnsBIRT
  3. Extract information from different columns into different rows - Unpivoting
    kathrin > Forum Questions > Extract information from different columns into different rows - Unpivoting
  4. Count repeated values
    elsamuel > Public > Count repeated values
  5. 01-Tidy Data (Solution)
    imagejan > Public > zidas2020 > Solutions > 01-Tidy Data (Solution)
  6. rsierrama - Count Values above threshold
    elsamuel > Public > rsierrama - Count Values above threshold
  7. 2017_08_01_frequentItems
    iris > Public > 02_ForumExamples > 2017_08_01_frequentItems
  8. Replace Values over Multiple Columns
    Data Manipulation Loopless Unpivoting
    +1
    This workflow demonstrates how to perform value replacement in multiple columns without u…
    ipazin > Public > 2020_03_12_Replace_Values_over_Multiple_Columns
  9. Sunburst Chart Coloring
    Workflows demonstrates how colors can be assigned for values in different segments of the…
    wiswedel > Public > Forum Questions > 2019 > Sunburst Chart Coloring
  10. Unpivot and Split
    tommy > Public > Unpivot and Split