Highlighted
Six Stars

union append in Talend

I have 2 different tables coming from 2 database. both have 3 columns. 'name', 'address' and 'email' . i want to merge these 2 data in talend itself. is there any component to do this?

 

 

name   address  email
mike shinoda   boulevard street, Montana   mshinoda@music.com

 

3 REPLIES
Twelve Stars TRF
Twelve Stars

Re: union append in Talend

Hi,
If schema are the same for both flows, you can use tUnite.
tMap can also be used in such a case as soon you have to filter input rows or transform anything.

TRF
Six Stars

Re: union append in Talend

i have kept column name same in all input tables, still if i use tUnite it saved column header each time. how can i get rid of this?

Twelve Stars TRF
Twelve Stars

Re: union append in Talend

With flows coming from databases ?
Looks very suspect.
Can you share your job?
I fthere is at least 1 input file, set the corresponding header to 1.

TRF