NodeDatabase Joiner (legacy)

Manipulator

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. 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.uk…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data
  2. In-Database Processing on SQL Server
    ETL KNIME Microsoft Azure In database Processing SQL Server
    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)
  3. Big Data Analytics - Model Selection to Predict Flight Departure Delays on Hive & Spark
    data blending data science machine learning Hadoop Spark model selection data preparation ETL airline data set flight delay
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData
  4. Big Data Preprocessing
    Hive Hadoop Big Data SQL in-database
    This workflow demonstrates the usage of the database nodes in conjunction with the Hive Connector node, which is part of…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example