Lookup join

This document is about Sigma datasets. For Sigma Workbooks, see the Lookup function and how to Add Columns through Lookup.

IMPORTANT: AllΒ elements must be on the same data connection.

Lookup.png

Lookup returns all of the rows in your current data and all of matching data from the rows in the joined data without adding any rows to the current data. When there is more than one match, Sigma shows a * to indicate that the joined data has more than one row with matching data. The Lookup join functions similarly to the VLOOKUP formula in Excel.

In the example below, we are using Lookup to join a customer information table with an order information table. We are using Customer ID, shown in columns CUST ID, as the Join Key. There is more than one order from Customer ID 1 in the order table, so Sigma displays a * in place of pulling in any information. This preserves the number of rows in the Customer Information Table.

Lookup_table.png

Different Joins handle multiple matching values differently.

lookup_table_2.png