.. _`VJoin Table`:

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

VJoin Table
~~~~~~~~~~~

.. image:: vjoin_table.svg
   :width: 48


Vertical join of two Tables.

For convenience, it is possible to duplicate the second port.  This makes
it possible to join several inputs using one nodes.

:Opposite node: :ref:`VSplit Table`
:Ref. nodes: :ref:`VJoin Tables pairwise`, :ref:`VJoin Tables`

*Input ports*:
    :port1: table

        Input Table
    :port2: table

        Input Table

*Output ports*:
    :port1: table

        Joined Table

*Configuration*:
    **Complement missing columns** (fill)
        Select if columns that are not represented in all Tables should be complemented
    **Complement strategy** (fill_strategy)
        When "Complement with nan or empty string" is selected missing columns will be replaced by columns of nan or empty strings. When "Mask missing values" is selected missing columns will be result in masked values
    **Output index** (output_index)
        Specify name for output index column. If left empty, no index column will be created
    **Increment for empty tables** (minimum_increment)
        Specify the increment in the outgoing index column for tables with no rows. Either 1 or 0.

.. automodule:: node_vjoin_tables

.. class:: VJoinTableNode


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

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