fbpx
Select Page

Right Outer Join

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

Lookup

Lookup returns all of the rows in your Current Worksheet and all of matching data from the rows in the Joined Data without adding any rows to the Current Worksheet. When there is more than one match, Sigma shows a * to indicate that the Joined Data has more than one...

Left Outer Join

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.In the example below, we are using Left Join to join a...

Join on a Calculated Column

Sometimes, you need to create join between Worksheets or Tables using a column of data that doesn’t exist in your data worksheet. Doing these kinds of joins takes a few extra steps.One case where you may need to join on a calculated column is joining your monthly...

Join New Data

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

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.