tMap filter rejects & expression filter

RVeitch_84 — Fri, 15 Nov 2024 23:44:10 GMT

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.

Re: tMap filter rejects & expression filter

Anonymous — Wed, 15 Sep 2021 01:27:55 GMT

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

topic Re: tMap filter rejects & expression filter in Talend Studio

tMap filter rejects & expression filter

Re: tMap filter rejects & expression filter