.. _`Pivot Tables`:

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

Pivot Tables
~~~~~~~~~~~~

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


Auto generated list version of :ref:`Pivot Table`.

In this version, the following ports from the original nodes have been
changed to lists which the node loops over:

    :Looped Inputs: Input.
    :Looped Outputs: Output.

For details see the original node.

*Input ports*:
    :Input: [table]

        Input Table

*Output ports*:
    :Output: [table]

        Output Table

*Configuration*:
    **Index column** (index)
        Column that contains a unique identifier for each new row
    **Column names column** (columns)
        Column that contains the new column names
    **Value column** (values)
        Column that contains the new values
    **Use zeros/empty strings instead of masks** (nomasks)
        When unchecked any positions in the output which arn't mentioned in the input will be masked. When checked such positions are instead assigned a zero value, an empty string, or some other value depending on the type of the values column.
    **Include index column** (include_index)
        Include a column with the index of each row.

.. automodule:: node_pivot_table

.. class:: PivotTables