CSV Pivot / Unpivot

Single file

Reshape between long and wide formats

Inputs
dataset
Outputs
dataset

Overview

Reshapes data between long and wide formats. Pivot turns row values into columns; unpivot melts columns back into key/value rows.

Fields

FieldDescription
Input variablerequiredWhich variable to use as the upstream dataset to read.
Modepivot (long → wide) or unpivot (wide → long).
ColumnsIndex, pivot, and value columns (pivot), or the columns to melt (unpivot).
Output variable namerequiredName this node's result so downstream nodes can select it. Auto-suggested; edit freely.

Try it

Open the node's real configuration, run it on the sample below, and see the result. Nothing is saved.

Sample input · data

monthcitysales
JanTunis10
JanSfax7
FebTunis12
FebSfax9

This is a live preview — the sample and results are temporary and never saved.