Talend - Merge Files

Trainer e-Mail: manask1703@gmail.com                                                                        Ph:+91 8099074539

Scenario 1:

• One file has 50 rows and another file has 30 rows
• If you want to combine both and need to get output as 80 rows

Solution:

• Read the both files with tFileInputFullRow
• Combine the files with tUnite component

Please find the screenshot below

Scenario 2:

• One Template File is there 
• Daily I am getting files and I expected format of Template file
• If format is same then I want process those.

Solution

• Read the both files with tFileInputDelimited
• Join (Left outer Join) the both files using with tJoin / tMap 
• Note: TemplateFile should be connect with Lookup  and capture the output from Main Section 

Please find the screenshot below