...
To create a self join:
- Open a workbook Workbook and add the data source.
Select "Edit" → Join or click - Click the "Join" icon.
- In this example of a self join, the goal is to use the employee names as a key to find if any employee has multiple roles. To do this, add the employee column and confirm with "Create Joined Sheet".
- The result is a self join using the employee names as a key and displaying matching records.
Joined Sheet Naming
...