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

Forteen 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.
Highlighted
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

Forteen 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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch