Copy data of one table into another table

I have two tables table 1 and table 2, table 1 contains repetitive values in its column and table 2 contains unique values in a column along with other data associated with these unique columns. I want to generate table 3 by copying the data of table 2 into table one. For clarification, please refer the imageimage
Please let me know if my question is still not clear. Thanks in advance.

Use Joiner node.

Hi @pardeepnaik -

As @izaychik63 mentioned, this is a classic use case for the Joiner node. You might find this video helpful for learning how to configure the node: