Force Update of Target Table

Hello team,

I am sending files to an Oracle DB. The error message is Unique Constraint violated. Given my settings in Visual Importer, I expected an update of the old record. Instead, it seems its trying to Insert, triggering the Oracle message. Any suggestions? Please note there  are 2 screenshots in the attachment. 

The update fields might have trailing spaces which are not visible.
Please try removing them using calculation

Just to clarify

Our software checks of record exits using count statement
select count(*) from table where field ='id '
Note single trailing space, so no record is found
When data inserted into oracle varchar field trailing spaces are automatically removed (BY ORACLE AND NOT US)
So the record actually exists but it has no trailing spaces and insert fails


  

Hello again Mike. Can you just confirm my understanding. Should I be adding trailing spaces when I insert a field that's part of the Primary Key, or removing it? For example:

SELECT TRIM(CAST(p.ID AS VARCHAR(100))) AS "LocationID"

You should trim it and also trim the the values which are already loaded

EG:
 
UPDATE  TABLE TABLE_NAME SET LocationID = TRIM(LocationID)

FYI:

Thanks. What does F1 refer to in TRIM([F1]) ?