.. _auto_dataset_transpose:

*DATASET TRANSPOSE*
===================

Transposes a dataset by pivoting rows into columns using a specified column as the new header row. Use this worker when you need to rotate tabular data so that rows become columns and vice versa.

When to use
-----------

Classification: **process**.

Tagged: ``dataset``, ``pivot``, ``reshape``, ``rows-to-columns``, ``transpose``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset_1
     - dataset
     - —
     - ✓
     - Input dataset to be transposed; must be a structured tabular dataset — rows will become columns after the operation.
   * - Cols In
     - cols_in
     - text
     - —
     - ✓
     - Name of the column whose values will become the new column headers after transposition; selected from the columns available in dataset_1.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - Transposed Dataset
     - dataset_transpose_o1
     - dataset
     - Resulting dataset after transposition, with original rows converted to columns and the selected column's values used as the new header labels.

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

.. 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_transpose</code>. Schema hash: <code>0ac5e3f29b8a</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>