Boost Query Performance and Data Efficiency with Semi-Joins and Anti-Joins (Generally Available)

You can now add semi and anti joins to your queries to identify duplicate and non-matching rows without coding. This update not only accelerates query performance by retrieving only essential data but also empowers you to perform advanced data analysis more efficiently, making complex data insights accessible to all. This feature is now generally available.

Where: This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: Open a lens. From the Add menu, select Join Data Source.

Select a join type and fields to match between the datasets. You can select up to 5 pairings.