Join Data

Description

This brick allows us to join two datasets horizontally by the specified shared columns. Works similarly to the 'JOIN' command in the SQL syntax.

Use

After connecting two datasets to brick's inputs, you must specify left and right join columns (in case of inner, right, left, and outer join type) and a join type (you may read about the 'JOIN' command in the SQL syntax to understand the difference between each type).
notion image

Example:

You can see the example here