Joining data connect data from different database tables or Sigma Worksheets.
- Click on the Data Source tab, located on the upper right hand side of the column panel.
- The Data Source panel displays all of the current sources. Click Add New to create a new Join.
- Choose whether you would like to join a table from your database, a Worksheet, or data selected using custom SQL.
- Once you have chosen your data source, you’ll choose which join options to use. Select which columns to use as the Join Key. The data in the join key must exist in both the Current Worksheet and the data you are joining. The columns used as the join key do not need to be visible in the Worksheet.
- Select the type of Join you would like to use.
- Hit Apply to see your Worksheet with the newly joined data!
Types of Joins
Lookup returns all of the rows in the Current Worksheet, and data from the matching rows in the Joined Data while maintaining the number of rows in the Current Worksheet. If Sigma finds more than one match for the Current Worksheet in the Joined Data, it returns a * in the corresponding row. Lookup functions like a VLOOKUP Excel function. Learn More
Inner Join returns the rows that exist in both the Current Worksheet and the Joined Worksheet. Removes all rows that do not have data in both the Current Worksheet and the Joined Data. Learn More
Left Outer Join returns all of the rows in the Current Worksheet and all the data from the matching rows in the Joined Data, adding rows when there is more than one match. This can result in an expanded row count. Learn More
Right Outer Join returns all of the rows from the Joined Data and the data from the matching rows in the Current Worksheet, adding rows when there is more than one match. When the Current Worksheet has more than one row that matches to Joined Worksheet, all of the matches rows are retained. Learn More
A Full Outer Join returns all of the rows from the Current Worksheet and all of the rows in the Joined Data, making matches where possible. Learn More
Different Joins handle multiple matching values differently.