Sunday, January 30, 2022

OIC - Merge two different schema files into a single CSV file

What :  We will read 2 csv files having different schemas and marge them into a single final csv file.

Input: 

Sample_1.csv


Sample_2.csv


Output:

Final.csv

Implementation Steps:

  • Create a FTP connection and create an Orchestrated integration.
  • Read 1st file using ftp connection and 1st CSV file schema.


  • Write the file in the Stage location with the same 1st CSV schema and map the read file.



  • Read the 2nd file using FTP connection and 2nd CSV file schema.


  • Write file into a stage location with the 2nd CSV schema. Keep the same file name and location. And also, keep Append to existing file checked in and map the read 2nd file.




  • Write the both marged file into a location using FTP connection.



No comments:

Post a Comment

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...