Reltio Integration Hub

 View Only

  • 1.  Reltio Integration Hub (RIH)

    Posted 10-20-2022 01:30

    Hi Everyone,

    We are working on creating accounts from Reltio as a source to other target systems, and we are facing issues in mapping our address attributes.

    Our Address is a Nested Attributes and are classified by address type (Primary, shipping, mailing) and survivorship rule for the address is Aggreation.

    so, we will have all the address that are of any address type or from any source as an OV.

    Now what we want to do is use a where clause on the address attributes, for example we want to send only addressline 1 as an input, where addresstype is equal to Primary= Addressline1.where("attributes.Address.AddressType":"Primary"),

    or

    image

    but we are not sure on how to use Reltio nested attributes in the where condition.



    ------------------------------
    Antony Anush
    Qlik
    ------------------------------


  • 2.  RE: Reltio Integration Hub (RIH)

    Reltio Partner
    Posted 10-20-2022 02:51
    Hi Antony,

    This is quite common with Nested attributes but still it is simple to achieve.

    We all know that the Address contains multiple attributes and also has label where we put Address Type either start or at the end and in my case, we have the label at the end and i tried this:
    For start: /^SHIPPING/
    For End: /SHIPPING$/
    Instead of having the value, just get the entire address nested block and check the label using regular expression then traverse it to get the AddressLine1 and its ov value.

    Hope this helps.


    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------

    Original Message