---
schema_version: "1"
id: 1e4dd766115019ffd60755979b5a6c7a045c301199159e4f43dcd073486f8cb6
title: Create Targeted Datasets with Single-Value and Multi-Value Lookup Joins
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/262-0-0/rn_dpe_debug_lookup_joins.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_dpe_debug_lookup_joins.htm&release=262.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e98956cce458117a8721766ec574c84a6b0ca0d7c4a69f616c322c72b121fbfb
description: Create a unique dataset by joining a primary and secondary data source with the Lookup join type. Preserve all records from the primary source and add matching data from the secondary source based on a common criteria. For example, match opportunity records (primary) with their corresponding account details (secondary) by using an account ID. If the secondary source has multiple matches, include data from only the first matching record or from all matching records in the resulting dataset for downstream nodes. Multi-value lookups aren't supported for Data 360 runtime definitions.
products:
  - Cross Cloud
release: "262"
---
# Create Targeted Datasets with Single-Value and Multi-Value Lookup Joins

Create a unique dataset by joining a primary and secondary data source with the Lookup join type. Preserve all records from the primary source and add matching data from the secondary source based on a common criteria. For example, match opportunity records (primary) with their corresponding account details (secondary) by using an account ID. If the secondary source has multiple matches, include data from only the first matching record or from all matching records in the resulting dataset for downstream nodes. Multi-value lookups aren't supported for Data 360 runtime definitions.

**Where:** This change applies to Lightning Experience in Professional, Enterprise, Unlimited, and Developer editions where Data Processing Engine is available.

**How:** In the Data Processing Engine builder, add a Join node and select **Lookup** as the join type. Select your primary and secondary sources, and then provide the match criteria by adding field mappings. To include multiple matches, select **Lookup multiple values**.

#### See Also

- [_Salesforce Help_: Joins](https://help.salesforce.com/s/articleView?id=ind.dpe_join.htm&language=en_US)
- [_Salesforce Help_: Lookup](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_join_lookup_multivalue.htm&language=en_US)