SPLIT ROWS TO COLUMS¶
Pivots a dataset from wide to long format by splitting selected columns into rows, producing a key-value pair representation. Each chosen column becomes a row entry with a feature-name column and a value column, anchored by a primary key. Use this worker when you need to unpivot/melt specific columns of a dataset for downstream analysis or reporting.
When to use¶
Classification: process.
Tagged: columns, dataset, melt, pivot, reshape, rows, split, transformation.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | Input dataset (wide format) to be reshaped; supply any tabular dataset whose columns you wish to unpivot into rows. | |
| Primary Key | primary_key | text | — | Name of the column that uniquely identifies each row and is retained as the anchor column in the output long-format dataset. | |
| Columns | columns_to_split | text | — | Comma-separated list of column names to unpivot; leave blank to apply the operation to all non-primary-key columns. Dynamically populated from the connected dataset. | |
| Name Column | name_col | scalar | Feature | Header label for the new column that stores the original column names after unpivoting; defaults to ‘Feature’. | |
| Value Column | value_col | scalar | value | Header label for the new column that stores the corresponding cell values after unpivoting; defaults to ‘value’. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Dataset | dataset_split_rows_output_1 | dataset | Reshaped long-format dataset containing the primary key column, a feature-name column, and a value column — one row per original (row, column) combination for each split column. |
Disciplines¶
- data.dataset.transform
Runnable example¶
A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: /api/workflow/example?id=dataset_split_rows
Auto-generated from transformation schema. Worker id: dataset_split_rows. Schema hash: 5451d1fce57e. Hand-curated docs in workerexamples/ override this page when present.