Join Inner (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 both data sets.

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 Inner (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 both the left input (input 1) and the right input (input 2). This will exclude records with keys only found in the left or right 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.

A value is required for this property.

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.