DB Joiner

This node joins two DB Data tables. The join is based on the joining columns of both tables.

Options

Joiner Settings

Join Mode

If a row from the top table cannot be joined with a row from the bottom 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 bottom table with missing values if no matching row exists in the bottom table. Likewise, a Right Outer Join will fill up the columns from the top table with missing values if no matching row in the top table exists. A Full Outer Join will fill up columns from both the top and bottom table with missing values if a row cannot be joined.

Joining Columns

Select the columns from the top input ('left' table) and the bottom input ('right' table) that should be used for joining. You must make sure, that the type of selected columns matches.
Match all of the following: A row of the top input table and a row of the bottom input table match if they match in all specified column pairs.
Match any of the following: A row of the top input table and a row of the bottom input table match if they match in at least one specified column pairs.

Column Selection

Column Selection (Top Input ('left' table) and Bottom Input ('right' table))

Select the left and right columns for the select clause in the join statement.

Duplicate Column Handling

The option allows you to change the behavior if the include lists of both input tables contain columns with the same name.
Filter duplicates: Only the columns from the top input table will show up in the output table.
Don't execute: Don't allow to execute this node if there are duplicate column names in the include lists.
Append suffix: Append a suffix to the duplicate column names from the bottom input table so that they also show up in the output table.

Joining Columns Handling

The option allows filtering the top ('left' table) or bottom ('right' table) joining columns, i.e. the joining columns defined in the Joiner Settings tab will not show up in the output table.

Views

This node has no views

Workflows

• 00_Getting_started_with_SnowflakeKNIME Hub
• 01 Data and Time and DatabasesKNIME Hub
• 01 Date and Time and DatabasesKNIME Hub
• 01 Date and Time and DatabasesKNIME Hub
• 01 Date and Time and DatabasesKNIME Hub
• Show all 445 workflows

Links

• Table Row to Variable - Challengeby mlauber71 on 2019-07-30

  forum.knime.com/p/66807
• Can we get the Excel Writer node to write/paste in the excel file starting on row 3by ipazin on 2022-11-04

  forum.knime.com/p/174123

Developers