Summary of Content

Lookup
Inner Join
Left Outer Join
R‍ight 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.

Lookup.png

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.

Inner_Join.png

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.

Left_Outer_Join.png

R‍ight 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.

Right_Outer_Join.png

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.

Full_Outer_Join.png