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

Highlighted
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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download