Reltio Connect

 View Only
  • 1.  Concatenating Addressline1 and Address line 2 for Reltio Cleanser in Address line 1

    Posted 16 days ago

    Hi Team,

    We have a business requirement to have Loqate cleansed Address line 2 concatenated with Address line 1 in Reltio.

    Upon trying the FullNameBuilder, we faced some limitations and hence wanted to check here if we have any other proposed solution for the same.

    Regards,
    Aanchal



    ------------------------------
    Aanchal Gupta
    One Trust
    ------------------------------


  • 2.  RE: Concatenating Addressline1 and Address line 2 for Reltio Cleanser in Address line 1

    Reltio Employee
    Posted 16 days ago

    You can look at mapping AddressLine1 and AddressLine2 individually in the inputmap, but in the output map only map DeliveryAddress to AddressLine1.  The DeliveryAddress should return all the cleanssed Address related fields in a single line.  You may then need to use surviviorship on AddressLine2 to OtherAttributeCrosswalkWinner on AddressLine1 to make sure it does not return any input to AddressLine2 if you are moving that data into AddressLine1 via the cleanser.  

    Details on those fields is available here: https://support.loqate.com/documentation/fielddescrip/addfields/



    ------------------------------
    Dan Gage
    Principal Solution Consultant
    ------------------------------



  • 3.  RE: Concatenating Addressline1 and Address line 2 for Reltio Cleanser in Address line 1

    Posted 9 days ago

    Hi Dan,

    I tried this and it seems to be working fine , but it is giving "<BR>" in between Addressline 1 and 2. Could you also suggest how to get rid of it?

    Refer to below screenshot-



    ------------------------------
    Aanchal Gupta
    One Trust
    ------------------------------



  • 4.  RE: Concatenating Addressline1 and Address line 2 for Reltio Cleanser in Address line 1

    Posted 7 days ago

    Hi Dan,

    Any updates?

    Regards,

    Aanchal



    ------------------------------
    Aanchal Gupta
    One Trust
    ------------------------------



  • 5.  RE: Concatenating Addressline1 and Address line 2 for Reltio Cleanser in Address line 1

    Posted 16 days ago

    Hi Anchal,

    Agree with Dan  Gage.

    But your business requirement mandates that you need to have address line1 and address line2 concatenated before address cleansing,  I would recommend that you concatenate them as part of the data loader functionality and map to Address Line1.

    Let me know if you need more information.

    Thanks

    RK



    ------------------------------
    Radhakrishnan Ramalingam
    Architect
    San Ramon CA
    ------------------------------



  • 6.  RE: Concatenating Addressline1 and Address line 2 for Reltio Cleanser in Address line 1

    Posted 13 days ago

    Thank you for your suggestions. We will try out suggested approach and will get back for any queries.

    Regards,

    Aanchal



    ------------------------------
    Aanchal Gupta
    One Trust
    ------------------------------