table with common structure

[Soumya_M]

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 ?

[Anonymous]

Hi

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