Reltio Connect

Hi ,

We have an requirement that if two matching records merged and one record has the value Active in Status field while the other has Inactive ,then always the record which is Active would survive.

Please let us know how to achieve this requirement.

Hi Utsa,

you can use survivorship rule is MinValue for Status field. The order will be calculated as per the "lexicographical sort order"

For Other attributes, you can use survivorship rule is "OtherAttributeWinnerCrosswalk" with the primaryAttributeUri=Status.

you can refer: "https://docs.reltio.com/en/model/consolidate-data/design-survivorship-rules/survivorship-rules"

You can make Status attribute primary for rest of the attribute in survivorship using OtherAttributeWinnerCrosswalk strategy and use min value for status to survive Active status. Further a combination of fallback would be needed to handle null and multiple Active status

Also Utsa, just one minor point I noticed in your question. You said you wanted the record with the active status to survive. In Reltio, records are not survived. Survivorship occurs at the attribute level within the merged record.