One Star

[resolved] update field in PostgreSQL table with tMap

He there,
since hours I try to solve a small (it seems for me big) problem...
I've a table: "Table_1" as tPostgressqlInput_1 --> tMap --> "Table_1" as tPostgressqlOutput_1
Now I try to update a field in "Table_1" via tMap. I wrote in the Output a value in the field.
In tPostgressqlOutput_1 I set "action on data" to "update". The job works fine... without any error... BUT the job doesn't change the value in this table... what I'm doing wrong?
thanks for help!
1 REPLY
One Star

Re: [resolved] update field in PostgreSQL table with tMap

He there,
since hours I try to solve a small (it seems for me big) problem...
I've a table: "Table_1" as tPostgressqlInput_1 --> tMap --> "Table_1" as tPostgressqlOutput_1
Now I try to update a field in "Table_1" via tMap. I wrote in the Output a value in the field.
In tPostgressqlOutput_1 I set "action on data" to "update". The job works fine... without any error... BUT the job doesn't change the value in this table... what I'm doing wrong?
thanks for help!

I found the problem... I was sooo stupid... ))) linking key to key and only in output schema this field what I wanted update...
and it's works...