topic Re: union append in Talend in Talend Studio

union append in Talend

Anonymous — Thu, 25 May 2017 16:55:23 GMT

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

Re: union append in Talend

TRF — Thu, 25 May 2017 17:17:51 GMT

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.

Re: union append in Talend

Anonymous — Fri, 26 May 2017 10:32:30 GMT

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?

Re: union append in Talend

TRF — Sat, 27 May 2017 05:32:35 GMT

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.