Start a new topic
Answered

Combined survirvorship rule

We would like to implement a survivorship rule that will choose the most frequent value but when there is a tie, we would like to use a ranking expression from a last modified date date field. Is that possible?


Best Answer

Absolutely. Implement your Most Frequent Value logic for the Consolidation Strategy. Then in the Ranking Expression, you can add your tie breaker logic. See the screenshot for an example:

We would like to implement a survivorship rule that will choose the most frequent value but when there is a tie, we would like to use a ranking expression from a last modified date date field. Is that possible?


1 Comment

Answer

Absolutely. Implement your Most Frequent Value logic for the Consolidation Strategy. Then in the Ranking Expression, you can add your tie breaker logic. See the screenshot for an example:

We would like to implement a survivorship rule that will choose the most frequent value but when there is a tie, we would like to use a ranking expression from a last modified date date field. Is that possible?


Login to post a comment