Page Comparison

To create a join:

1. Open a workbook and click on the "Join" icon or click on "Edit" → "Join". The 'Create a Joined Sheet' dialog opens. 
   Image RemovedImage Added or Image RemovedImage Added
2. Select the required /wiki/spaces/DASSB100/pages/32569527080 from the drop-down within the 'Simple' tab. 
   Image RemovedImage Added 
3. Unfold the workbook sheet and column menu and position the required columns via drag and drop on the appropriate fields. 
   Image RemovedImage Added 
4. Select "Included columns" to display the content and select the columns you want to have displayed in the result join sheet. 
   Image RemovedImage Added 
5. Confirm with "Create Joined Sheet". The new joined sheet appears in the workbook. Joining Data is finished.  
   Image RemovedImage Added
   Image RemovedImage Added
   
   

Anchor
multi multi

Creating a Join From Multiple Columns

...

1. Open a workbook and add the data sources that need to be joined together in a workbook in different sheets.
   Image Removed Image AddedImage Removed
2. Click on the "Join" icon or click on "Edit" → "Join". The 'Create a Joined Sheet' dialog opens.
   Image RemovedImage Added or Image RemovedImage Added
3. Unfold the workbook Workbook sheet and column menu and position the required columns via drag and drop on the appropriate fields.
   Image RemovedImage Added
4. Click the "+" button to and add additional column keys to the join. 
   INFO: The same data source must be used in the left and right columns as the previous data sources.
   INFO: If you want to join data from multiple sheets, use the "+" button at the bottom right side of the tab 'Simple' to create pins from multiple data sources. 
   Image Removed Image Added
   Image Removed Image Added
5. Select "Included columns" to display the content and select the columns you want to have displayed in the result join sheet. 
   Image RemovedImage Added

6. Confirm with "Create Joined Sheet". The result is displayed in the joined workbook. Multiple joining is finished. 

   Image RemovedImage Added
   Image RemovedImage Added

Anchor
range_join range_join

Creating a Ranged Join

Info
title 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 User Time Jeff 17/10/2015 Mike 17/10/2015 Sheet 2 Value Time 45345 18/10/2015 92383 19/10/2015 Create a range join by Sheet 1.Time is less than Sheet 2.Time. Deselect Sheet 2.Time under "Included Columns". Sheet1.User Sheet1.Time Sheet2.Value Jeff 17/10/2015 45345 Jeff 17/10/2015 92383 Mike 18/10/2015 92383

...

To create a self join: 

1. Open a workbook Workbook and add the data source.
   Image RemovedSelect "Edit" →  Join or click Image Added
2. Click the "Join" icon.
   Image Added
3. 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".
   Image RemovedImage Added
4. The result is a self join using the employee names as a key and displaying matching records.
   Image RemovedImage Added

Joined Sheet Naming

...