There are multiple join nodes in Sparkflows.
- join advanced
- Join using common columns
- Join using column
- Join using sql
These nodes make it easy to handle various join scenarios seamlessly.
Join using common columns - it makes it easy to join two datasets by using the columns with same names in all datasets
Join using common column : it makes it easy to join datasets when there is one common column
Join using sql - it enables joining 2 or more datasets by writing a sql.