Reltio Integration Hub

 View Only

  • 1.  Joining 2 Files of different structures in RIH

    Reltio Partner
    Posted 02-06-2023 08:44
    Is it possible to join 2 CSV files of different structures in RIH, using a common field/attribute, before loading the data into Reltio tenant?

    ------------------------------
    Abhik Das
    Tata Consultancy Services
    ------------------------------


  • 2.  RE: Joining 2 Files of different structures in RIH

    Reltio Employee
    Posted 02-06-2023 09:48
    @Daniel Gage, @Ayan Basu @Michael Pearlman can one of you help? ​​​

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

    Original Message


  • 3.  RE: Joining 2 Files of different structures in RIH

    Reltio Employee
    Posted 02-06-2023 09:55
    Hi you might look into using the SQL Transformation. It can use CSV as an input stream and then you can perform SQL operations. I haven't done this myself but here is the documentation https://docs.workato.com/features/sql-transformations-actions.html#input-fields

    ------------------------------
    Michael Pearlman
    ------------------------------

    Original Message


Related Content