Mergeing columns of 2 excel file with different schema

Five Stars

Mergeing columns of 2 excel file with different schema

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

Thirteen Stars

Re: Mergeing columns of 2 excel file with different schema

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: Mergeing columns of 2 excel file with different schema

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

Thirteen Stars

Re: Mergeing columns of 2 excel file with different schema

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Fifteen Stars TRF
Fifteen Stars

Re: Mergeing columns of 2 excel file with different schema

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
Fifteen Stars TRF
Fifteen Stars

Re: Mergeing columns of 2 excel file with different schema

@Pankaj18, did this help?

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


TRF

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.