Skip to main content

Join (AX)

Synopsis​

This operator attempts to provide the same functionality as the Join tool in Alteryx.

Description​

This operator attempts to provide the same functionality as the Join tool in Alteryx.

**This code is the proprietary and confidential information of Altair Engineering Inc. All use of this code is subject to the terms of Altair's non-disclosure agreement and partnership agreement. The code is strictly prohibited from distribution without prior written permission by Altair. **

Input​

left​

An ExampleSet containing the left side of the join.

An ExampleSet containing the right side of the join.

Output​

left​

An ExampleSet containing all rows contained in left that are NOT contained in right (i.e. left inner join).

join​

An ExampleSet containing the inner join of the two sets.

right​

An ExampleSet containing all rows contained in right that are NOT contained in left (i.e. right inner join).

Parameters​

Left​

The left attribute join key. Note the data type of this attribute should match the data type of the right attribute.

Right​

The right attribute join key. Note the data type of tis attribute should match the data type of the left attribute.

Attributes​

Each row represents information about each attribute including: field, selected (True/False), rename (optional feature). If values for rename do not exist then 'none' should be written instead. Note that the row describing whether *Unknown is selected or deselected should always exist in this parameter.

Reorder​

Indicates whether there was a reorder (this is only relevant for migrated Alteryx workflows). Note that reordering can be done manually in the attributes parameter.