topic unable to update field from one table to another in Talend Studio

unable to update field from one table to another

DM2017 — Thu, 08 Feb 2018 09:46:42 GMT

Hi,

I am trying to update one field(serverslno) in a table from another table (which is key column primary key of the table) based on a join condition, but it's not working.

I have a table actor inserting data to actor_new

tmysqlinput(actor) >> tmap>>tmysqloutput(actor_new) >>tmap>>tmysqlout(actor)

ID genrated in actor_new should go to one column called serverslno in actor. first insert is working fine but update not working.

Screenshots attached.

Please help.

Re: unable to update field from one table to another

TRF — Thu, 08 Feb 2018 09:54:27 GMT

Hi,

actor_id of "rr" flow must be populated in the tMap as it is the update key for the update.

Re: unable to update field from one table to another

manodwhb — Thu, 08 Feb 2018 10:01:25 GMT

in tMap,you have not mapped the Key column(that is input column for actor_id).

Re: unable to update field from one table to another

TRF — Thu, 08 Feb 2018 10:08:28 GMT

@manodwhb, what is the added value compared to the previous answer?

Re: unable to update field from one table to another

DM2017 — Thu, 08 Feb 2018 10:12:48 GMT

@TRF I understood. But this is not that case, here I want to update serverslno of actor with key column of actor_new. Previously it was a look up. but this is straight forward.

Re: unable to update field from one table to another

TRF — Thu, 08 Feb 2018 10:18:59 GMT

actor_id field is ticked as the Update Key for the update operation so it cannot be null.

As it is not mapped in the preceding tMap it is null so you need to add it.

Re: unable to update field from one table to another

TRF — Sun, 11 Feb 2018 08:10:06 GMT

Hi,
Does this help?
If so thank's to mark your case as solved.