Skip to main content

Join (In Database)

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​

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.