This deprecated node joins two input data sets and only outputs records either found only in the right data set or in both data sets.
In total, there are six variations of deprecated Join nodes that have been replaced by a single Join node. You can now perform all join variations within a single node, see Join.
This node joins input from both files, using the comparison expression to determine if the specified data is in the right input (input 2), or in both inputs. This will exclude records with keys only found in the left input. The inputs must be in properly sorted order (as specified by the join expression), or SortLeftInput or SortRightInput should be set to true.
Properties
SortLeftInput
Optionally specify whether the first input will be sorted on the LeftInputKey.
The default value is False.
SortRightInput
Optionally specify whether the second input will be sorted on the RightInputKey.
The default value is False.
LeftInputKey
Specify an expression relative to the first (left) input, used to determine the key on which to join.
RightInputKey
Optionally specify an expression relative to the second (right) input, used to determine the key on which to join.
By default the value specified for LeftInputKey is used.
Inputs and outputs
Inputs: left, right.
Outputs: out1, multiple optional.