tMap filter rejects & expression filter

[RVeitch_84]

I'm trying to do a simple lookup to filter some data for an Insert,Update,Delete into a DB.

Here is my example job:

 

My insert filter rejects works fine:

But I can't seem to get the update to work:

Here is my raw data, and for the update I would like to just filter if the names are not equal to each other and then push what is in the nav data?

In this senerio, Oscar name has changed, so I would expect to ovewrite Oscar with Oscarr.

[Anonymous]

Hello

For the updating, you need to select the rows which already exists in target DB, so the 'Catch lookup inner join reject' property should be false. In addition, use the function string1.equals(string2) to check whether two strings are equal.

Regards

Shong