Multi-level survivorship rule (publisher priority / most recent value)
Cédric Blanc
started a topic
about 2 years ago
I need to configure a multi level survivorship rule such that within highest priority source I select most recent value from the records. Can you assist?
For example, I am trying to use multiple attribute ( PublisherID, Status) and using custom ranking option in the survivorship rule.
The ranking expression has the following query
CASE UPPER(PublisherID)
when 'MKT' then 1
when 'CRM' then 2
when 'HR' then 3
when 'MANUAL' then 4
else 5
end
ASC,
CASE UPPER(Status)
WHEN 'ACTIVE' THEN 1
WHEN 'CLOSED' THEN 2
WHEN 'DNU' THEN 3
ELSE 4
END ASC,
COALESCE(Orders, 0) DESC
COALESCE(LastUsedDate,MAKE_DATE(1900,1,1))DESC
To elaborate further, the rule picks the preferred publisher ( highest ranked is ‘MKT’) and status (highest ranked is ‘Active’) and also picking up the lasted record by ordering on Last used date.
For example, I am trying to use multiple attribute ( PublisherID, Status) and using custom ranking option in the survivorship rule.
The ranking expression has the following query
CASE UPPER(PublisherID)
when 'MKT' then 1
when 'CRM' then 2
when 'HR' then 3
when 'MANUAL' then 4
else 5
end
ASC,
CASE UPPER(Status)
WHEN 'ACTIVE' THEN 1
WHEN 'CLOSED' THEN 2
WHEN 'DNU' THEN 3
ELSE 4
END ASC,
COALESCE(Orders, 0) DESC
COALESCE(LastUsedDate,MAKE_DATE(1900,1,1))DESC
To elaborate further, the rule picks the preferred publisher ( highest ranked is ‘MKT’) and status (highest ranked is ‘Active’) and also picking up the lasted record by ordering on Last used date.
Cédric Blanc
I need to configure a multi level survivorship rule such that within highest priority source I select most recent value from the records. Can you assist?
To configure a multiple level survivorship rule using the multiple attribute and highest ranking you will need to use a case statement. The syntax for case is in the following link - https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/SemQL/functions.html#_case_expression
For example, I am trying to use multiple attribute ( PublisherID, Status) and using custom ranking option in the survivorship rule.
The ranking expression has the following query
To elaborate further, the rule picks the preferred publisher ( highest ranked is ‘MKT’) and status (highest ranked is ‘Active’) and also picking up the lasted record by ordering on Last used date.
Cédric Blanc
To configure a multiple level survivorship rule using the multiple attribute and highest ranking you will need to use a case statement. The syntax for case is in the following link - https://www.semarchy.com/doc/semarchy-xdm/xdm/5.3/SemQL/functions.html#_case_expression
For example, I am trying to use multiple attribute ( PublisherID, Status) and using custom ranking option in the survivorship rule.
The ranking expression has the following query
To elaborate further, the rule picks the preferred publisher ( highest ranked is ‘MKT’) and status (highest ranked is ‘Active’) and also picking up the lasted record by ordering on Last used date.
-
Can we reset Matches and run again on match rule change or add a new match rule?
-
"Unmerge" records
-
Turn off match rules to speed up an integration job
-
Can anyone tell me how to load a Fuzzy-Matched entity ... but skip the matching happening auto-magically?
-
Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
-
How can I trigger a "match on child records"?
-
How can I Configure Most Frequent Values in Survivorship Rules?
-
Deterministic or probabilistic matching
-
Machine Learning and AI for matching
-
Prevent loads from replacing values overridden by users
See all 40 topics