Combine data from 2 tables into one table

[Former Member]

Hi All,

I have 2 tables having same structure (One Column Emp ID).

First Table is having Emp IDs 1 to 10.

Second Table is having Emp Ids 11 to 20.

I need to merge those Tables..
Please tell me which transform I need to use (Merge Transform?)

Regards.

[Former Member · Accepted solution]

Hi,

As per your query.

go for merge transform.  Just simple take your 2 tables and map with merge transform.

Out put : 1 to 20

[mageshwaran_subramanian]

As long as table structure , data type and their length are same , MERGE transform can be used