Join Data


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


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


You can see the example here