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.

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

Last updated

Was this helpful?