Adding a Join Operator
Used to join data sources using common keys.
- On the Application page, click
and select Join 
in the Add Operator pane.
The Join node
icon displays in the Graph pane, as well as the properties to be defined in the Operator Settings pane, and the preview of the data in the Schema pane.
The left (inbound) edges allow you to select the input sources or operators that will be joined. The right (outbound) edge allows you to connect to other operators.
- In the Operator Settings pane, define or select the following required properties:
Property Description Node ID
The ID of the join operator.
Inputs
The left input automatically connects to the currently-selected operator. You can select another ID of the operator that will be the source of the data in the Inputs drop-down list.
Then select the right input.
The preview of the data (LEFT, RIGHT, and OUTPUT) are displayed in the Schema pane.
Time Window
The time window for the join operation (in milliseconds)
Join Type
The type of the join: INNER, LEFT, or OUTER
Left Field
The columns from the left source that will be used to join with.
Right Field
The columns from the right source that will be used to join with.
NOTE: Node ID, Inputs, Join Type, and Left Field with Right Field properties are required.
- In the Fields List section, click . The key columns of the left and right sources are automatically displayed.
Repeat step 3 to add more columns.
You can also:
- Select the topmost check box to select all of the fields
- Delete a field entry in the Field List by selecting its check box and clicking
The LEFT, RIGHT, and OUTPUT schema are displayed.
- Save the changes.
Example
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.