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. 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

  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.uk…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data

  3. 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

  4. Dimensionality Reduction

    This workflow shows 7 methods for dimensionality reduction: 1. High ratio of missing values 2. Low variance 3. High corr…
    shima0011 > 04_Analytics > 01_Preprocessing > 02_Techniques_for_Dimensionality_Reduction

  5. 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)