Talend community forum / join and update

neosz · 2012-03-30 17:51:11

Hello, I'm new to Talend,

I have 2 tables: table1, table2

For each row of table1, I need to know if table1.attribute1 has a corrispondent value in table2.attribute2.

After that I need to update table1.attribute3 with value 'Y'.

Anyone can suggest me how to do it?

Thanks in advance.

phobucket · 2012-03-30 18:38:51

What database are you using? You could do this entirely within the db using a t<db>Row component, but the syntax varies slightly based on the database.

MySQL example

"UPDATE table1, table2
SET table1.attribute3 = 'Y'
WHERE table1.attribute1 = table2.attribute2"

neosz · 2012-03-30 19:35:13

Oracle 10

neosz · 2012-03-31 10:29:59

and if the two tables were in different databases?

janhess · 2012-04-02 09:54:24

Use tMap to join the tables. Pass table1 key and attribute to output and set the attribute to "Y". Pass output to tdatabasetypeOutput and set for update.

neosz · 2012-04-02 11:32:09

I'll try. Many thanks

Announcement

Unanswered posts

#1 2012-03-30 17:51:11

join and update

#2 2012-03-30 18:38:51

Re: join and update

#3 2012-03-30 19:35:13

Re: join and update

#4 2012-03-31 10:29:59

Re: join and update

#5 2012-04-02 09:54:24

Re: join and update

#6 2012-04-02 11:32:09

Re: join and update

Board footer