Loading
Salesforce now sends email only from verified domains. Read More
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Lookup

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Lookup

            In CRM Analytics, a lookup returns all rows from the left data stream (recipe data) and only matching rows from the right data stream (lookup source). If multiple matches are found in the right data stream, you can set the lookup to return either a single row or all matching rows. To ensure that the grain of the results doesn’t change, the lookup outputs one row for each row in the left data stream.

            Required Editions

            Available in Salesforce Classic and Lightning Experience.
            Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition.

            Example

            Our company's marketing team captures demographic data in an external data source for opportunities stored in Salesforce. To help create more targeted campaigns, the team is building a dashboard that segments our current opportunities by the customer demographics. Let’s use a lookup to add the demographic data to each opportunity record.

            Consider the following two data streams. The left data stream contains opportunity records. The right contains demographic data. To illustrate how the lookup handles special cases, both data streams contain unmatched rows and duplicate keys.

            The left data stream shows the opportunity ID, customer name, and opportunity amount. The right data stream shows the opportunity ID and educational level.

            If the lookup is configured to return a single match when multiple matches are found, the lookup produces the following results based on the matching keys.

            The new dataset contains columns from both data streams.

            All rows from the left, including rows without a match, are included in the results. Although Cust_ID 1 has two matches on the right, the lookup returns only the first matching record. Also, because Cust_ID 4 doesn’t have a match, the Cust_id and Education Level columns are null and Average Income is 0 for that record. Unmatched dimensions are set to null. Unmatched measures are set to 0.

            If the lookup is configured to return all matching values when multiple matches are found, the lookup produces the following results based on the matching keys.

            The new dataset contains columns from all matched values for each left row.

            A multiple-match lookup returns the same results as the single-match lookup, except for left rows that have multiple matches. Unlike a single-match lookup, a multiple-match lookup returns all matches and combines them. For dimension columns, it generates a multivalue column with all dimension values—notice how High School and Secondary School are both in the Education Level column for Cust_ID 1. For measure columns, it adds the measure values from all matched records. For Cust_ID 1, the Avg Income column is 98,000 (50,000 + 48,000).

            Note
            Note The Preview tab doesn’t show all values in a multivalue column. Instead, it shows the first value only. Keep this behavior in mind when you preview the results of a multiple-match lookup. In the example, notice that the Preview tab shows only High School in the Education Level column even though the column contains High School and Secondary School.
            The new dataset contains columns from all matched values for each left row.

            See Also

             
            Loading
            Salesforce Help | Article