Joiner

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.