Joiner (deprecated)

This node joins two tables in a database-like way. The join is based either on the row IDs of both tables or on the row ID of the first table and an arbitrary column from the second table.
If you want to join based on two columns, you first have to set the row IDs from either table by using the Row ID node.

Options

Join column from second table

Select the column from the second input table that should be used for joining. You may selected a real column or the table's row ID here. You must make sure, that the type of selected column matches the type of the row ID in the first table! If e.g. the row IDs in the first table are StringCells and the selected column from the second table are IntCells joining will fail although they may contain the same numbers.

Duplicate column handling

The option allows you to change the behaviour if both input tables contain columns with the same name. If "Don't execute" is selected, the node will not be executed i.e. it stays red. The second choice is to filter the duplicate columns, i.e. only the columns from the first input table will show up in the ouput table. As a third option you can append a suffix to duplicate column names so that they are also available at the output table.

Join mode

If a row from the first table cannot be joined with a row from the second table (and vice versa) there are several options of handling this situation. After an Inner Join only matching rows will show up in the output table. A Left Outer Join will fill up the columns that come from the second table with missing values if no matching row exists in the second table. Likewise, a Right Outer Join will fill up the columns from the first table with missing values if no matching row in the first table exists. A Full Outer Join will fill up columns from both the first and second table with missing values if a row cannot be joined.

Multiple-match row ID suffix

If several rows from the second table match to one row from the first table, the row ID from the first table's row is extended by this suffix and a number. In some cases it is necessary to manually change the suffix if the extended row ID is equal to an existing row ID (which causes DuplicateRowKeyExceptions).

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers