Hub
Pricing About
WorkflowWorkflow

Joiner

JoinerJoinCombineNode bitesNight heron data
nightherondata profile image
Draft Latest edits on 
May 29, 2023 11:48 AM
Drag & drop
Like
Download workflow
Workflow preview
Combining data sets is one of the most common and important operations during data processing. The Joiner node allows you to combine two tables according to one or more common, or key, fields. The section Include In Output has three check boxes which allow you to create different types of joins. We encourage you to try all combinations of turning boxes off and on. Pay attention to the diagram on the right, as it indicates which type of join the selected options creates. By default, the results of the join are output through the uppermost output port. In this default configuration, the middle and lower ports are inactive. However, by selecting the "split results" option, you can view the left, inner, and right outputs in the three output ports. This is helpful when evaluating the results of the join operation. On the Column Selection tab there are two sets of include/exclude boxes. The upper box corresponds to the columns in the top input, the lower for the bottom input. Make sure to check the appropriate "enforce inclusion" or "enforce exclusion" options to ensure the correct columns pass through the join.
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.2
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.2

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits