Reltio Connect

hi,
We have a requirement to merge two sources when the crosswalk primary key is the same. e.g. Source1 Pkey is A1234  and Source2 Pkey A1234. I believe reltio has the ability to do this but i cannot find it in the documentation. Can you please indicate how this can be done.

Hi Peter,

In your example, since the crosswalk sources are different, Reltio does not consider their primary keys to be the same. So, if each crosswalk belongs to a different entity and you want to merge the entities, you can either merge the entities manually (https://docs.reltio.com/mergeapis/mergingtwoentities.html) or specify match rules for each entity  (https://docs.reltio.com/matchmerge/matchruleconfig.html).  

Hope this helps!​

Hi Peter,

Since the crosswalk sources are different, the primary keys are not exactly the same. In this case, we have two options to merge:

1. Do a manual merge of the entities: https://docs.reltio.com/mergeapis/mergingtwoentities.html.
2. Set a match rule: https://docs.reltio.com/datamodeler/creatematchrule.html.

Hope this helps!

Hi Peter,

Hi @Peter C,

You can employ match rules , in this case may be an automatic match Rule to match & merge the data coming in from sources when the primary key is same . may be something similar to the below .

{
"uri": "configuration/entityTypes/HCP/matchGroups/Rule1",
"label": "Rule1-Exact(PrimaryKey)",
"type": "automatic",
"scope": "ALL",
"useOvOnly": "true",
"rule": {
"matchTokenClasses": {
"mapping": [
{
"attribute": "configuration/entityTypes/HCP/attributes/PrimaryKeyFieldName",
"class": "com.reltio.match.token.ExactMatchToken"
}
]
},
"comparatorClasses": {
"mapping": [
{
"attribute": "configuration/entityTypes/HCP/attributes/PrimaryKeyFieldName",
"class": "com.reltio.match.comparator.BasicStringComparator"
}
]
},
"and": {
"exact": [
"configuration/entityTypes/HCP/attributes/Identifiers/attributes/PrimaryKeyFieldName"
]
}
},
"scoreStandalone": 0,
"scoreIncremental": 0
}​