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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.