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.

Input Ports

Icon
Input table with at least one value column for the unpivoting operation.

Output Ports

Icon
Unpivoting table with duplicated columns together with rotated value columns and their corresponding column names.

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.