I was able to achieve the objective with the following rule. Note the filter to eliminate bad emails from consideration:
"rule": {
"matchTokenClasses": {
"mapping": [
{
"attribute": "configuration/entityTypes/Individual/attributes/MiddleName",
"parameters": [
{
"parameter": "groups",
"values": [
{
"pattern": "^.",
"className": "com.reltio.match.token.ExactMatchToken"
}
]
}
],
"class": "com.reltio.match.token.CustomMatchToken"
}
]
},
"comparatorClasses": {
"mapping": [
{
"attribute": "configuration/entityTypes/Individual/attributes/MiddleName",
"parameters": [
{
"parameter": "groups",
"values": [
{
"pattern": "^.",
"className": "com.reltio.match.comparator.BasicStringComparator"
}
]
}
],
"class": "com.reltio.match.comparator.CustomComparator"
}
]
},
"and": {
"exact": [
"configuration/entityTypes/Individual/attributes/FirstName",
"configuration/entityTypes/Individual/attributes/LastName",
"configuration/entityTypes/Individual/attributes/Email/attributes/Email"
],
"exactOrNull": [
"configuration/entityTypes/Individual/attributes/MiddleName"
],
"exactOrAllNull": [
"configuration/entityTypes/Individual/attributes/NameSuffix"
],
"notEquals": [
{
"values": [
"none@noemail.com",
"pleaseupdateemail",
"no@mail.com"
],
"uri": "configuration/entityTypes/Individual/attributes/Email/attributes/Email"
}
]
}
}
------------------------------
Matthew Gagan
Reltio
------------------------------
Original Message:
Sent: 07-17-2024 15:42
From: ujwal upadhyay
Subject: How to match initials
Hello!
We are trying to implement something similar.
How did you set up you .txt file for the string replacement cleanser to get this working?
Thanks!!
------------------------------
ujwal upadhyay
fultonbank
Original Message:
Sent: 11-21-2022 12:18
From: Ashish Rawat
Subject: How to match initials
Thanks Gino, The regex which wasn't working via custom match rule, works with string replacement cleanser :)
------------------------------
Ashish Rawat
Manager
Fresh Gravity
Bangalore
Original Message:
Sent: 11-15-2022 09:55
From: Gino Fortunato
Subject: How to match initials
Hi Ashish,
If you want to stick to capabilities within a match rule, it looks like you should be able to use the string replacement cleanser to convert the middle name to the first initial. Doing this on a first initial and on a full middle name will yield you a string of the first initial and therefore a match.
https://docs.reltio.com/en/explore/get-a-crash-course/get-ready-to-turn-your-data-into-action/learn-about-multidomain-mdm/reltio-match-merge-and-survivorship/match-group-elements---description-and-configuration/rule-element/match-cleansers/string-replacement-cleanser
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 11-11-2022 07:04
From: Ashish Rawat
Subject: How to match initials
In every MDM implementation match on middle name is a every common scenario but its implementation seems complex. I am looking for a solution to match records where one of the matching pair have middle name as J. and other pair has in as Jhon. I have tried using regular expression but no luck, any suggestions?
------------------------------
Ashish Rawat
Manager
Fresh Gravity
Bangalore
------------------------------