• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Updata table instead of truncate table

#1 2011-05-03 17:45:00

orhan
New member
Registered: 2011-02-07
Posts: 4

Updata table instead of truncate table

Tags: [excel, mysql, table]

Hi guys,


I'm very new with talend. I want that talend updates data from excel into my db because of mistyping. For example I have columns year, name and number.
In the first run of my job in talend the excel data gets into my db. In the second run now I want that just the data with e.g. the same year (1. run: name= smith, year=2010, number=5; 2. run: name=smith, year=2010, number=6smile get updated because I mistyped in excel. I don't want that talend truncate my table but steadily continue my table in the db every time I run the job. Sorry for my english and thank you for answers.

Offline

#2 2011-05-04 03:37:37

alevy
Member
Registered: 2009-11-20
Posts: 1567

Re: Updata table instead of truncate table

Use Action on Data setting: Insert or Update?

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Updata table instead of truncate table

Board footer

Powered by FluxBB