Mergeing columns of 2 excel file with different schema

[Anonymous]

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

[manodwhb]

@Pankaj18,read two excel files and do the join in ID in tMap or tJoin.

[Anonymous]

but it requires same data and what about when data is not same like i want to append 2nd file

[manodwhb]

@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.

[TRF]

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.

[TRF]

@Pankaj18, did this help?

If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).