MERGE TWO TABLES

[mahesh_Dev]

HOW TO MERGE HELP ME

INPUT DATA:

TABLE 1

COLUMN1   COLUMN2   COLUMN3

 a                    RED                ROSE

 b                     BLUE                WATER

c                     BLACK               DARK

TABLE 2

COLUMN1   COLUMN2   COLUMN3

 d                    GREEN         PLANTS

OUTPUT

COLUMN1   COLUMN2   COLUMN3

 a                    RED                ROSE

 b                     BLUE                WATER

c                     BLACK               DARK

 d                    GREEN         PLANTS

[Anonymous · Accepted solution]

Hi,

     Could you please use tunite component for your use case? Since the column structure remain same for both tables, this component will help you to merge the data.

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/oOmTuZBOs48JO~TJlNwA7Q

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[mahesh_Dev]

Dude nilkhilthampi  thanks for helping you solution helped me

[Anonymous]

Hi  Nikhil,

I have the same requirement, but different DB and column structer are not same.

Thanks,

Merge.PNG