...
| Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||
A ranged join is similar to a simple join but has additional versatility. Instead of joining worksheets using an exact matching key column, you can specify a range (greater than, less than) between two worksheet key columns. Data types allowed by a range join are limited to dates and geolocations, e.g. Sheet 1
Sheet 2
Create a range join by Sheet 1.Time is less than Sheet 2.Time. Deselect Sheet 2.Time under "Included Columns".
|
...
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
...