...
| 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".
|
...