table with common structure

Soumya_M — Thu, 20 Jul 2023 11:31:21 GMT

Hello all, I need our help regarding populating of a table

--lets say I have 3 tables with 3 columns:

table_1 | table_2 | table_3

record_type(=1) | record_type(=2) | record_type(=3)

A_num | A_num | A_num

B_num | B_num | B_num

I want a resultant table with common structure:

table_4

record_type

A_num

B_num

according to the record type, the data should get populated accordingly. How to achieve this in talend ?

Re: table with common structure

Anonymous — Mon, 24 Jul 2023 01:50:05 GMT

Do you want to merge the tree tables into one table? Can you explain your requirement with some example data? That will be helpful for us to understand your problem.

Regards

Shong

topic table with common structure in Talend Studio

table with common structure

Re: table with common structure