This deprecated node joins two input data sets and only outputs records found in the left data set.
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 left input (input 1) only. This will exclude records with keys only found in the right input, or found in both inputs. 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.