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.