.. _auto_dataset_split_rows:

*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
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - 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
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - 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 <https://www.d3view.com/api/workflow/example?id=dataset_split_rows>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_split_rows</code>. Schema hash: <code>5451d1fce57e</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>