Unpivoting

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

This list contains the names of the columns that are rotated into one single column.

Retained columns

Include

This list contains the column names of the columns which are duplicated by the number of selected value columns.

Manual Selection

Filter

Use one of these fields to filter either the Include or Exclude list for certain column names or name substrings.

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

Enforce Inclusion

Select this option to enforce the current inclusion list to stay the same even if the input table specification changes. If some of the included columns are not available anymore, a warning is displayed. (New columns will automatically be added to the exclusion list.)

Enforce Exclusion

Select this option to enforce the current exclusion list to stay the same even if the input table specification changes. If some of the excluded columns are not available anymore, a warning is displayed. (New columns will automatically be added to the inclusion list.)

Wildcard/Regex Selection

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.

Type Selection

Select the column types that you want to include. Column types that are currently not present are depicted in italic.

Enable hiliting

Select, if hiliting is enabled between input and output data.

Skip rows containing missing cells

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

Views

This node has no views

Workflows

• [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
• 0_MS-DIAL_MS-Finder_v6_JSSX 1v1KNIME Hub
• 00 Data GenerationKNIME Hub
• 01_AnalyticsKNIME Hub
• Show all 778 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 17 links

Developers