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.
- join type Specifies which join should be executed.
- key attributes The attributes which shall be used for join. Attributes which shall be matched must be of the same type.
- keep both join attributes If checked, both columns of a join pair will be kept. Usually this is unneccessary since both attributes are identical.