Update and Insert the records in the existing table

[Anonymous]

Hi,

As i have the existing table , in which i need to perform the update and insert option.

It  means i need to insert new records and also update the existing records.

Please suggest me 

Thanks.

[Anonymous]

If you have source table already created , then if you doing sync with target you can use ELT component, it can update or insert

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/X2VBExDJD3rEIaYGZOp0Fw

If you are performing anything by extracting source like applying any rules to transform data and than load, at that point you need to create a temporary table and make that temporary table as source and than do synchronizing which merging by using that above ELT componentm that ELT will work most types of databases,

or else you can follow this link below for the solution

https://community.talend.com/t5/Design-and-Development/Update-and-Insert-the-records-in-the-existing...

[Anonymous]

Similar issue with Excel files.

I have a job which brings in an Excel Spreadsheet.  The job was set up and works great.

Since then I received another Excel spreadsheet but a new field has been added and needs to be brought into the output.

Seems I cannot find a way(unless deleting previous) to sync up the new file for the process?  Is there a way or does it always need for someone to DELETE the Input and recreate it from scratch?

[modara]

Dear Concern,

I have one MSSQL table to take to MYSQL.

I set Primary key

As I have one table so i dont use tMAP

in action table: create table , action data: insert

then i insert 12 data from mssql to mysql

then change

in action table: default , action data: insert or update

then i insert 5 data in mssql but when i click RUN mysql takes all 17 data

not just the newly inserted data into mssql

your help is much appriciable

thanks