Join Between

Joins two tables based on a selected column value in the TOP input table being between the values in the BOTTOM input table

12 November 2022 @takbb Brian Bates

Options

Include Left unmatched rows

Tick this to include the rows from the Left (upper) input table that do not match with the Right (lower) input table.%%00010(Left Outer Join)

Columns to return from Source table on TOP/LEFT data port

Select the columns to be returned from the table on the TOP (LEFT) data port

Columns to return from Lookup/Enrichment table on BOTTOM/RIGHT data port

Select the columns to be returned from the table on the BOTTOM (RIGHT) data port

Name of Lookup column marking the START of the range

Choose the column from the BOTTOM port data table that marks the START of the range to be compared

Name of Lookup column marking the END of the range

Choose the column from the BOTTOM port data table that marks the END of the range to be compared

Column from TOP input table to be compared

Choose the column that is to be matched to the range

Nodes

• Column Selection Configuration3 ×
• Merge Variables3 ×
• Column Filter Configuration2 ×
• DB Writer2 ×
• Extract Column Header2 ×
• Show all 15 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available