One of the most common requirements where you are reading two files from FTP and want to merge the data of these two files to create a consolidated file. Both the files should have one common field using which you can create a consolidated file.
As per the below image, there are two separate files, one file is having the employee’s data however the second file is having the employee’s contact information. Both the files are having the common field called EmployeeId basis on which I want to merge these two files and create one consolidated file.
In the consolidated file, we will have all the employee’s fields + contact field (concat all the contacts of an employee).
I have captured a short video on the solution. Click on the below link to view the complete solution.
Subscribe to my YouTube channel to get regular updates.