You are not logged in.
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.
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 ?
In the advanced setting of tMysqloutput, you can choose columns which are updateable or not.