Reltio Connect

We have a requirement to generate a unique ID for every address based on the address fields (Addressline1, city, state, and country) since addresses are nested attributes in the organization entity. Is there a way in Reltio to generate a unique ID similar to a hash key using address fields with cleanser functions?

This sounds like what the "Surrogate" function does. When an address relation is created, if you specify in your "refEntity" a value of "Surrogate", it generates a hash based on the address fields you have specified. See https://docs.reltio.com/en/model/construct-your-data-model/define-or-refine-your-data-model/define-crosswalks-for-data-sources/configuring-surrogate-keys

Pradhap,

1. Why are addresses defined as nested attributes instead of reference attributes? You can generate auto IDs for nested attributes .  Here is the doc: Auto-generated IDs for Simple and Nested Attributes.

   If this approach doesn't work, you'll need to create the MD5 hash outside of Reltio, using RIH, LCA, or as part of the data load process. You can also generate the MD5 in Excel and then load it. However, one potential issue I foresee is handling the cleansed value.

Let me  know