Start a new topic
Answered

How can I Configure Most Frequent Values in Survivorship Rules?

Is it possible in the survivorship to add a condition depending of Master values? If at least 2 master records have the same value, the survivor will be the most frequency values, Else If AttributeA=AttributeB then AttributeB.ValueB .


Best Answer

If I have understood your question correctly: when you have a Consolidation Strategy of 'Most Frequent Value' for a particular named attribute and there is a need for a tie break to determine the value from which Master Record, then you can use a Ranking Expression to choose which survives.

 

CASE WHEN attrA = attrB THEN 10 ELSE 20 END ASC

 

1 Comment

Answer

If I have understood your question correctly: when you have a Consolidation Strategy of 'Most Frequent Value' for a particular named attribute and there is a need for a tie break to determine the value from which Master Record, then you can use a Ranking Expression to choose which survives.

 

CASE WHEN attrA = attrB THEN 10 ELSE 20 END ASC

 

Login to post a comment