Copy data of one table into another table

KNIME Analytics Platform
1

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.
Regards,
Pardeep

2

Use Joiner node.

3

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: https://www.youtube.com/watch?v=9uV99ByH-TA