Reltio Integration Hub

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
------------------------------

@Daniel Gage, @Ayan Basu @Michael Pearlman can one of you help? ​​​

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

Original Message:
Sent: 02-06-2023 08:30
From: Abhik Das
Subject: Joining 2 Files of different structures in RIH

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
------------------------------

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:
Sent: 02-06-2023 09:48
From: Chris Detzel
Subject: Joining 2 Files of different structures in RIH

@Daniel Gage, @Ayan Basu @Michael Pearlman can one of you help? ​​​

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

Original Message:
Sent: 02-06-2023 08:30
From: Abhik Das
Subject: Joining 2 Files of different structures in RIH

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
------------------------------