Reltio Connect

 View Only

  • 1.  Source Columns has multiple values for a single Attribute in Reltio

    Reltio Partner
    Posted 07-11-2023 08:32

    Hi ,

    we had a requirement to load data from a file to Reltio Using RIH, whereas for one particular column we have multiple values separated by pipe delimiter(IN|US|DC),

    we want want to load those data into Reltio Attribute as single attribute value , can someone help me in achieving this.



    ------------------------------
    Karthik
    PWC
    ------------------------------


  • 2.  RE: Source Columns has multiple values for a single Attribute in Reltio

    Reltio Employee
    Posted 07-12-2023 09:30

    @Daniel Gage  any guidance from your end on this? Or do you know someone that can help? 



    ------------------------------
    Chris Detzel
    Director of Customer Community and Engagement
    Reltio
    ------------------------------

    Original Message


  • 3.  RE: Source Columns has multiple values for a single Attribute in Reltio

    Reltio Employee
    Posted 07-13-2023 13:22
      |   view attached

    Karthik,

    I did something exactly similar to this parsing names separated by semicolon in a single field to create an array that you can use as a data pill to populate a multi-valued attribute.  

    The attached document has the details.



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

    Original Message


  • 4.  RE: Source Columns has multiple values for a single Attribute in Reltio

    Reltio Partner
    Posted 07-18-2023 01:36

    Hi Karthik,

    You can simply use .split function so that it creates an array in Reltio step.

    Make sure to provide the actual delimiter and you will get all values as OV.



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

    Original Message


  • 5.  RE: Source Columns has multiple values for a single Attribute in Reltio

    Reltio Partner
    Posted 07-19-2023 08:41

    Hi Sheshadri,

    Thanks for the input, it worked



    ------------------------------
    Karthik
    PWC
    ------------------------------

    Original Message


  • 6.  RE: Source Columns has multiple values for a single Attribute in Reltio

    Reltio Partner
    Posted 07-19-2023 08:50

    Hi Karthik,

    Glad to know that the suggestion worked.



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

    Original Message