merge two table rows under one column header

[modara]

Dear Concern,

I have two table with same meta data or column header

table 1- custID, custName, custDOB

table 2- custID, custName, custDOB

in these two tables data are different

table1- 1, abc, 2-10-1984

table-2- 2, xyz, 3-9-1970

I need to keep column name same as they are

How can I merge these data field in one table under same column name

table1- 1, abc, 2-10-1984

table2- 2, xyz, 3-9-1970

final table-

custID, custName, custDOB

1 abc 2-10-1984

2 xyz 3-9-1970

above will be the final output

Please help me steps to do this

thanks in advance

[manodwhb]

@Not defined Not defined​ , you need to use tUnite to merge the data. check the below link to know more about.

https://www.tutorialgateway.org/talend-unite/

Thanks,

Manohar

[Anonymous]

Hello,

Are you trying to add user defined header row(custID, custName, custDOB) in your output file?

If so you can add separately headers to the files before writing data to it.

tFixedFlowInput--main--tFileOutputdelimited (write custID, custName, custDOB)

|onsubjobok

write data to existing file.(Append append existing file)

Let us know if it is what you are looking for.

Best regards

Sabrina