Joining General Information
INFO
Joining data allows to create a new workbook sheet, containing columns from two or more sheets based on a pre-defined key column.
INFO
A joined worksheet is based on sample data defined from the data source.
When first creating a joined worksheet, the displayed data is based on the current sampling of data. After the workbook has been run, the joined sheet calculations are applied to the full data.
When creating a joined sheet that displays no data, the UI informs you in an info message that the empty sheet is displayed based on the current sample data. Running the workbook again creates. a new sampling for the sheets that take into account the calculation of the joined sheet.
Types of Joins
Inner Join
An inner join returns only the set of records that are contained in both Sheet A and Sheet B.
Full Outer Join
A full outer join returns the set of all records in Sheet A and Sheet B, with matching records from both sides where available. If there aren't any matches, the affected records are paired with a null value.
Outer Left Join
An outer left join returns a complete set of records from the left sheet, Sheet A, with the matching records (where available) in Sheet B. If there aren't any matches, the affected records are paired with a null value.
Outer Right Join
An outer right join returns a complete set of records from the right sheet, Sheet B, with the matching records (where available) in Sheet A. If there aren't any matches, the affected records are paired with a null value.
Self Join
A self join combines a sheet with itself returning related records from the same sheet. Self joins are useful when one record falls into two categories.
Example: A list of employees would show that John is an analyst, but also that he is head of the department. With a self join you could show that he belongs to both groups.