topic Re: MERGE TWO TABLES in Talend Studio

MERGE TWO TABLES

mahesh_Dev — Sat, 16 Nov 2024 07:30:06 GMT

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

Re: MERGE TWO TABLES

Anonymous — Wed, 10 Oct 2018 05:51:03 GMT

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

Re: MERGE TWO TABLES

mahesh_Dev — Thu, 11 Oct 2018 05:26:11 GMT

Dude nilkhilthampi thanks for helping you solution helped me

Re: MERGE TWO TABLES

Anonymous — Thu, 08 Aug 2019 17:28:31 GMT

Hi Nikhil,

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

Thanks,

Merge.PNG