Reltio Connect

 View Only
Expand all | Collapse all

Concatenate multiple attributes from multiple nest and use that value to populate a simple attribute

  • 1.  Concatenate multiple attributes from multiple nest and use that value to populate a simple attribute

    Posted 05-14-2024 23:54

    Hello Folks,

    I am looking for a way to concatenate multiple attributes from multiple nest and use that value to populate a simple attribute.

    For example consider that I have an entity - HCP,  entity - Location, relation - HCP to Location.

    A single HCP can be related to multiple Locations. We are pulling some attributes of Location(State & Country) inside HCP as reference attributes in a nest called Address.

    An attribute in HCP, say Notes should contain the concatenated values of State, Country from all Locations that the HCP is associated with.

    HCP 1 ---------------> Location 1 (State - California, Country - US)

    HCP 1 ---------------> Location 2 (State - Texas, Country - US)

    HCP 1's Notes attribute should contain the value - California, US + Texas, US

    I am trying to see if any of the Out of the BOX cleanser will work and if I can avoid the of use LCA.



    ------------------------------
    Aditya Somayajula
    ------------------------------


  • 2.  RE: Concatenate multiple attributes from multiple nest and use that value to populate a simple attribute

    Reltio Employee
    Posted 05-15-2024 19:36

    Hi Aditya,

    While I can't think of a way to do this with a cleanser, you should probably do this after the fact by listening to the queue and having RIH or your favorite integration product do it for you.



    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------