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.