HJoin Table¶
HJoin 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 the column from the lower port will take precedence and the corresponding column from the upper port will be lost.
The second port can be duplicated, making it possible to join several inputs using one node. To join a dynamic number of tables use HJoin Tables.
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 1 - 1, table
Input Table
- port2 1 - inf, table
Input Table
Output ports¶
- port1 table
Table with horizontally joined data
Configuration¶
- Complement missing rows (mask)
Select if rows that are not represented in all Tables should be complemented with masked values
- Input port name for joined table (name)
Select which port decides the output table(s) names
- 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.HJoinTable[source]
