HJoin Tables

../../../../_images/hjoin_table.svg

HJoin a list of Tables into a single Table, stacking columns next to each other

Documentation

The operation of horizontal join, or HJoin, stacks the columns in the incoming Tables horizontally, next to each other. The colunms in the output Table will be union of columns from the input Tables.

If the option ‘Complement missing rows’ is unchecked (the default) then all the inpnut Tables must have the same number of rows. Otherwise, Tables with fewer rows are padded with masked values.

If a column name exists in more than one input Table such columns from Tables later in the list will take precedence and the corresponding columns from Table earlier in the list will be lost.

Table name

The node always tries to give the output table a name, so if the chosen port has a table without name, the other port will be used. This is to preserve backwards compatibility.

Definition

Input ports

port1 [table]

Input Tables

Output ports

port1 table

Table with horizontally joined data from the incoming list of Tables.

Configuration

Complement missing rows (mask)

Select if rows that are not represented in all Tables should be complemented with masked values

Rename duplicate columns (rename)

If true columns with same name as an earlier column will be renamed and joined, otherwise columns will overwrite existing data

Examples

Implementation

class node_hjoin_tables.HJoinTablesSingle[source]