topic Re: merge two table rows under one column header in Talend Studio

merge two table rows under one column header

modara — Sat, 16 Nov 2024 00:37:38 GMT

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 — Tue, 02 Mar 2021 07:25:06 GMT

@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 — Tue, 02 Mar 2021 08:23:21 GMT

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