Help center Get started Knowledge center Product documentation API documentation
Product
Lens Weave Maskbits
Overview
Data
Data Import Output Result
Data Preparation
Cleansing Imputation Duplicates Filter Fuzzy Filter Outlier Treatment Binning Trimming Validation Sorting
Transformation
Data Transformation Bulk Data Transformation Merge Union Fuzzy Merge Encoding Normalization Scaling Standardization Aggregate Unpivot Functional Transformation SQL Executor
Statistical Plots
Box Plot Correlation Histogram Pair Wise Line Plot Scatter Plot Bar Plot Stem Plot Step Plot Fill Between Stack Plot Descriptive Statistics
Workflow Agent
Workflow Agent
Scheduler
Scheduler
Library
My Workflows Shared Workflows Audit
Datasource
Datasource
Datasource Management
Data Model
Connectors Management
Admin
Admin
User Management Roles Management Group Management Organization Management

Overview

The Unpivot node is a transformation node in a Weave Workflow that transforms columns into rows, producing a compact long-format table that is easier to analyze. It sits in the middle of a Workflow’s processing path between source nodes (Data Import) and terminal nodes (Result, Output) and emits the reshaped data downstream.

Configuration is two parts: select one or more columns to unpivot, and name the two output columns, Field Header (holds the original column names) and Field Value (holds the values from the selected columns).

Note: “Workflow” is the in-UI term for what some Weave documentation calls a pipeline. This reference uses “Workflow.”

When to use it

  • Converting a wide table with many columns into a long, two-column key/value form.
  • Reshaping data for analysis or downstream nodes that expect long-format input.
  • Collapsing several measure columns into a single value column tagged by name.

Configuration

FieldDescription
UnpivotChoose one or more columns to unpivot. Opened via Select; Select All chooses every column.
Field HeaderName of the new column that will hold the original column names.
Field ValueName of the new column that will hold the values from the selected columns.

Output

Output elementDescription
Field Header columnOne row per selected column, containing that column’s original name.
Field Value columnThe value from each selected column, aligned to its name in the Field Header column.

Key behaviors

Unpivot is a transformation node. Unlike Data Import (source) and Result / Output (terminal), it sits in the middle of the Workflow, receiving data upstream, reshaping the selected columns into rows, and passing the result downstream.

Columns become rows. Each selected column is turned into a row pairing the original column name (Field Header) with its value (Field Value), increasing row count and reducing column count.

Output names are user-defined. The Field Header and Field Value column names are entered during configuration and label the two output columns.