.. _`Unpivot Table`:

.. _`org.sysess.sympathy.data.table.unpivottablenode`:

Unpivot Table
~~~~~~~~~~~~~

.. image:: pivot_table.svg
   :width: 48






Documentation
#############
Unpivot a Table.

The inverse operation of Pivot Table. The operation transforms data from a
wide to a narrow format. The wide form can be considered as a matrix of
column values, while the narrow form is a natural encoding of a sparse
matrix. When the data types of value columns differ, the varying data is
converted to a common data type so the source data can be part of one
single column in the new data set.

Definition
##########
*Input ports*:
    :Input: table

        Input Table

*Output ports*:
    :Output: table

        Output Table

*Configuration*:
    **Index column** (index)
        Column that contains a unique identifier for each row

.. automodule:: node_unpivot_table

.. class:: UnpivotTable






Example flows
#############

* :download:`PivotTable.syx </_examples/Sympathy/Data Processing/Structure/PivotTable.syx>`