Types of Joins
Summary of Content
Lookup
Inner Join
Left Outer Join
Right Outer Join
Outer Join
Full Outer Join
Lookup
Lookup returns all of the rows in the current data and data from the matching rows in the joined data while maintaining the number of rows in the current data. If Sigma finds more than one match for the current data in the joined data, it returns a * in the corresponding row. Lookup functions like a VLOOKUP Excel function. Learn more.
Inner Join
Inner Join returns the rows that exist in both the current data and the joined data. Removes all rows that do not have data in both the current data and joined data. Learn more.
Left Outer Join
Left Outer Join returns all of the rows in the current data 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
Right Outer Join returns all of the rows from the joined data and the data from the matching rows in the current data, adding rows when there is more than one match. When the current data has more than one row that matches to joined data, all of the matches rows are retained. Learn more.
Full Outer Join
A Full Outer Join returns all of the rows from the current data and all of the rows in the joined data, making matches where possible. Learn more.
Different joins handle multiple matching values differently.