Join Node Functionality

How do I merge datasets using the Join Node?

The Join Node merges datasets based on common keys:

Join Types:

• Inner Join: Returns only matching records
• Left Join: Returns all left table records + matches
• Right Join: Returns all right table records + matches
• Full Outer Join: Returns all records from both tables

Configuration:

1. Select join type
2. Choose join keys from each dataset
3. Handle duplicate column names
4. Preview results before execution