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.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.