Suppose i have two excel files student1(ID,Name,Branch,City,country) and student2(ID,Name,city) and I want to combine data in these files
@Pankaj18,read two excel files and do the join in ID in tMap or tJoin.
@Pankaj18,yes you should have the same data. what is your exact requirement? if you want to generate single file from those both then you need to go with tUnite,tUnite should have have same order of columns and data types .in this case you need to set default values for the second file Branch,country by using tMap.
I gave you the answer in your other post https://community.talend.com/t5/Design-and-Development/Merging-two-tables/m-p/134218#M83641
Thank's to mark your topics as solved.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema