Talend community forum / [resolved] Fill column on insert but not update (tmap)

r.hills · 2009-12-18 09:57:32

I am using tMap in order to update/insert records inside a mysql database from a csv file.

Currently I have a column in my database which records the record creation date.
Quite simply, on an insert I wish to fill this column, however on an update I dont want to touch it.

Can this be done? And if so how would I do this.

Thank you in advance.

r.hills · 2009-12-21 08:47:09

Bumping this, surely its possible?

I have a single flow within which I will update or insert.
on update I want to not touch the column "creation_date"
on insert I want to fill the column "creation_date"

How would I go about doing this ?

Thank you.

shong · 2009-12-21 10:23:52

Hello
In the advanced setting of tMysqloutput, you can choose columns which are updateable or not.

Best regards

shong

Uploaded Images

r.hills · 2009-12-21 10:28:37

wonderful, thank you again shong.

Announcement

Unanswered posts

#1 2009-12-18 09:57:32

[resolved] Fill column on insert but not update (tmap)

#2 2009-12-21 08:47:09

Re: [resolved] Fill column on insert but not update (tmap)

#3 2009-12-21 10:23:52

Re: [resolved] Fill column on insert but not update (tmap)

#4 2009-12-21 10:28:37

Re: [resolved] Fill column on insert but not update (tmap)

Board footer