Unpivot

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

Options

Value columns

Include/exclude columns

This list contains the columns that are rotated into one single column.
Manual selection:

• Buttons: Use these buttons to move columns between the Include and Exclude list. Single-arrow buttons will move all selected columns. Double-arrow buttons will move all columns (filtering is taken into account).
• Any unknown columns: Controls what happens with new columns when the input table changes. If this placeholder is in the include list, then new columns are included, otherwise they are excluded.

Wildcard/Regex:

• Pattern: Type a search pattern which matches columns to move into the Include or Exclude list. Which list is used can be specified. You can use either Wildcards ('?' matching any character, '*' matching a sequence of any characters) or Regex. You can specify whether your pattern should be case sensitive and whether the pattern defines the includes or the excludes.

Types:

• Selected types: Select the column types that you want to include.

Skip rows containing missing cells

Skip all rows containing missing cells in the selected value column(s).

Retained columns

Include/exclude columns

This list contains the columns which are duplicated by the number of selected value columns.
Manual selection:

• Buttons: Use these buttons to move columns between the Include and Exclude list. Single-arrow buttons will move all selected columns. Double-arrow buttons will move all columns (filtering is taken into account).
• Any unknown columns: Controls what happens with new columns when the input table changes. If this placeholder is in the include list, then new columns are included, otherwise they are excluded.

Wildcard/Regex:

• Pattern: Type a search pattern which matches columns to move into the Include or Exclude list. Which list is used can be specified. You can use either Wildcards ('?' matching any character, '*' matching a sequence of any characters) or Regex. You can specify whether your pattern should be case sensitive and whether the pattern defines the includes or the excludes.

Types:

• Selected types: Select the column types that you want to include.

Performance

Enable hiliting

Advanced setting that if selected enables hiliting between input and output data.

Views

This node has no views

Workflows

• [01] F1 - Download DataKNIME Hub
• [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
• [04.CX] Capturing Messenger LiveChat Data in Real-Time with ManyChat and Google SheetsKNIME Hub
• 00 Data GenerationKNIME Hub
• 00 Data GenerationKNIME Hub
• Show all 1461 workflows

Links

• transpose particular columns to rowsby ipazin on 2018-08-14

  forum.knime.com/p/46467
• How to replace multiple values in different columnsby armingrudd on 2019-10-07

  forum.knime.com/p/71840
• Transform matrix into single row valuesby armingrudd on 2019-10-14

  forum.knime.com/p/72264
• Pivoting with multiple columnsby HansS on 2019-12-10

  forum.knime.com/p/76641
• Use of Pivoting or Unpivotingby tommy on 2021-04-07

  forum.knime.com/p/120259
• Show all 18 links

Developers