unable to update field from one table to another

Highlighted
Six Stars

unable to update field from one table to another

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.

Capture.JPGCapture1.JPGCapture2.JPGCapture3.JPGCapture4.JPG

Screenshots attached. 

Please help. 


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: unable to update field from one table to another

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

TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: unable to update field from one table to another

Hi,

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


TRF
Forteen Stars

Re: unable to update field from one table to another

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Fifteen Stars TRF
Fifteen Stars

Re: unable to update field from one table to another

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


TRF
Six Stars

Re: unable to update field from one table to another

@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.

Fifteen Stars TRF
Fifteen Stars

Re: unable to update field from one table to another

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.


TRF
Fifteen Stars TRF
Fifteen Stars

Re: unable to update field from one table to another

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

TRF

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now