Look up values from another table in Visual workspace

When to use it

Enriching rows with master data (customer region, account name).

How

Add step → Combine → Look up. Choose the lookup table, the key in each table (both are column pickers), the columns to bring, and whether rows with no match are kept or quarantined.

Look up segment from customers on customer_key

• Missing keys never match each other.
• The lookup key must be unique in the lookup table.

Pitfalls

• Fan-out from a non-unique lookup key.
• Missing keys matching each other in pandas.
• Inner joins that drop rows silently.