What is the Expression and how to use it

Learn how to define Expressions in Delpha to detect exact duplicate matches using AND/OR logic on fields like email, phone, or LinkedIn URL. Improve your data accuracy with precise matching formulas.

What is the Expression and How to Use It

Expression evaluation is the first step of Delpha’s duplicate detection process. An Expression is a formula that determines whether two records are a 100% match based on specific fields. It can use logical AND, OR, or a combination of both.

Expressions are configured using JSON-style syntax and must use fields defined in the Fields section.

From version 3.56, we've replaced the old JSON-based interface with a new visual rule builder to simplify and streamline duplicate rule configuration.

Expression Syntax Explained

Expression Type	Example	What it Means
AND: [["field1", "field2"]]	[["Email", "Name"]]	Records match if both Email and Name are the same.
OR: [["field1"], ["field2"]]	[["Email"], ["Phone"]]	Records match if either Email or Phone is the same.
Combination of AND & OR	[["LinkedInURL1__c", "LinkedInURL2__c"], ["Name", "Email"]]	Records match if either LinkedIn URLs match or Name and Email both match.

Important Notes

• Fields used in the Expression must be configured in the Fields section of your duplicate detection settings.

• Expressions only identify exact matches and are often used to complement fuzzy matching algorithms later in the process.