Insert or update on duplicate key but not update all fields

[Anonymous]

I am trying to load data into a dimension table. It is straight forward enough, if the record does not exist, created it. If the record does exist update it. Setting "Action on data" to "Insert or update on duplicate key or unique index" in my tMysqlOutput step does basically what I am looking for. However, when updating, I do not want to update all fields. There are couple that I want to keep as the current value while updating all the other fields. It is not clear to me how I can set the action at the individual field level. Any help would be greatly appreciated.
Thanks,
Jason

[Anonymous]

P.S. Sorry, I'm new on inserting images here. Sorry again...
P.P.S. BTW, are there any guides how to insert those "beautiful" screenshots right in the messages? I can't manage to find any of these.

[Anonymous]

Hi erop,
If you register and log in as a Community member, you'll get a Image upload box that allows to upload screen captures and images up to 200KB.
For registered users, I realized that the image upload feature is only available when clicking on "post reply" (not through the quick post").

Best regards
Sabrina

[Anonymous]

Many thanks, Sabrina! I swear I'll never use "Quick post" option

[alevy]

You've specified the update key as code_federal but you are not populating that field in the tMap!

[Anonymous]

You've specified the update key as code_federal but you are not populating that field in the tMap!

Thank you, alevy, so much! As usual for me, the solution was so obvious and simple

[Anonymous]

No, tMysqlOutput_1_QUERY is never populated.

alevy, have you any ideas about approaches on debugging/logging resulting SQL query in tMysqlOutput component?

[alevy]

I've seen the question asked a few times on the forum but I don't think there's a way to do it in Talend since it uses prepared statements. You would have to look at the DB logs. Having said that, you can certainly at least see the data you're sending to tMysqlOutput with a tLogRow.

[Anonymous]

Thank you, alevy!