NodeNode / Manipulator

Database Joiner (legacy)

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

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

Input ports
  1. Top Input ('left' table) Type: Database Query
    Table contributing to the left part of the output table
  2. Bottom Input ('right' table) Type: Database Query
    Table contributing to the right part of the output table
Output ports
  1. Joined table Type: Database Query
    Joined Table
  1. Big Data Analytics - Model Selection to Predict Flight Departure Delays on Hive & Spark
    data blending data science machine learning +7
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to …
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData
  2. 01_Bioactivity_Prediction_Load_Pull_Data
    This workflow is the first one executed by the model factory. It pulls the data from the ChEMBLdb (https://www.ebi.ac.u…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data
  3. In-Database Processing on SQL Server
    ETL KNIME Microsoft +3
    This workflow shows how to perform in-database processing on Micrsoft SQL Server. It starts with a dedicated SQL Server…
    knime > Examples > 40_Partners > 01_Microsoft > 01_SQL_Server_InDB_Processing(Azure)