Join (In Database)
(In-Database Processing)
Synopsis
Performs a join operation between two inputs using the specified keys.Description
This operator implements the well-known (equi-)join operation. It can be inner, left, right or outer join. The list of keys can be defined in a parameter. The operator can remove duplicate columns (based on their name), or keep them.
Input
left- right
Output
- union
Parameters
- remove_double_attributes Indicates if double attributes should be removed or renamed. Range: boolean
- join_type Specifies which join should be executed. Range: selection
- key_attributes The attributes which shall be used for join. Attributes which shall be matched must be of the same type. Range: list
- keep_both_join_attributes If checked, both columns of a join pair will be kept. Usually this is unneccessary since both attributes are identical. Range: boolean