PQ - Merge or Append - Confused - Merge 2 tables & use existitng columns

[harishs]

Hi Expert,
looking for solution.

I want to merge 2 tables using EMP ID to match and load information from Table2 to Table1 within the exiting column?
Table 1 -500 rows with 50 columns
Table 2 - 50,000 rows with 200 columns
Columns name in both the tables are same.

Regards,
Harish S

 

[Matt Allington]

Look at the icons in the menu that represent merge vs append. This tells you what each one does. Merge adds new columns from one table to another. Append adds new rows.