Join Left (Superseded) - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

Joins two input data sets and only outputs records found in the left data set.

Note: This node has been superseded by the Join node which provides similar functionality, but the underlying code is Python rather than Data360 Analyze Script. The Join Left (Superseded) node is provided for backwards compatibility, but where possible it is recommended that you use the new Join node.

In total, there are six variations of Join node that have been superseded by the new 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.