• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Need help for the usage of "update" data in output

#1 2009-11-18 13:35:22

gavelin
Member
Registered: 2009-11-12
Posts: 12

Need help for the usage of "update" data in output

Hi
I dont need to obtain a working "update" for an import of data :

my first table, for input :

Cahier_input
------------
Format
NomCahier
NomEdition
datePublication

I got a lookup table :

Parution
------------
idEdition
idParution
NomEdition
datePublication

The join is made on (Nom Edition,datePublication) for the lookup.

I want to feed a table Cahier_Output with NomCahier (from Cahier_input) and idParution(from Parution).
The idCahier field is auto-incremanted :

Cahier_output
-------------
idCahier
NomCahier
idParution

When i set "Action on data" on the component Output on "Insert", all is fine.
But i want that when the "Cahier_input" is loaded again, the data of "Cahier_output" to be updated for the Cahier_input rows where the couple {idParution, NomCahier} already exists in "Cahier_Output"

I try to specify  "action on data" of "cahier_output" component on "update or insert" and i have specified in the "advanced settings" tabs the fields "idParution" and "NomCahier" as keys for update, but it doesn't work.

What is the good way to proceed ??


Uploaded Images

Offline

#2 2009-11-19 08:08:09

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: Need help for the usage of "update" data in output

Hello

When i set "Action on data" on the component Output on "Insert"

Try the action 'insert or update'

Best regards

         shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Need help for the usage of "update" data in output

Board footer

Powered by FluxBB