topic Re: tFilterRow AND operator in Talend Studio

tFilterRow AND operator

mauerwegrunner — Tue, 03 May 2022 06:57:38 GMT

Hello,

the job processes 4 rows of data:

Now with activated filter surname not null AND familyname not null I expect the row with bot null values being filteres out:

However this results emerges:

Why is surname TOM and familyname Kreuzberg is filtered out?

Re: tFilterRow AND operator

gjeremy1617088143 — Tue, 03 May 2022 07:11:22 GMT

Hi, as a workaround , you can negate the two conditions like: equal to null and use the reject row, it will works

Send me love and kudos

Re: tFilterRow AND operator

mauerwegrunner — Tue, 03 May 2022 07:32:40 GMT

Hi gieremy...,

thanks for your swift answer. The solution works. However, what I need to understand is, why the AND operator does not combine the two filters. My understanding is: only rows with surname and familyname == null should be filtered out. Tom and Kreuzberg should remain in resultset. Maybe I am projecting SQL logic on this condition?

Re: tFilterRow AND operator

Nehls16450 — Tue, 03 May 2022 09:14:35 GMT

I faced similar kind of issue last time, I am still searching for some proper solution Same issue still no fix to this.

Re: tFilterRow AND operator

gjeremy1617088143 — Tue, 03 May 2022 14:33:19 GMT

this is what i found in the help center:

Select a logical operator to combine simple conditions and to combine the filter results of both modes if any advanced conditions are defined.

And: returns the boolean value of true if all conditions are true; otherwise false. For each two conditions combined using a logical AND, the second condition is evaluated only if the first condition is evaluated to be true.

Or: returns the boolean value of true if any condition is true; otherwise false. For each two conditions combined using a logical OR, the second condition is evaluated only if the first condition is evaluated to be false.

Re: tFilterRow AND operator

gjeremy1617088143 — Tue, 03 May 2022 14:36:42 GMT

so use OR condition if you want TOM and familyname Kreuzberg

Re: tFilterRow AND operator

Anonymous — Mon, 09 May 2022 03:07:32 GMT

Hello,

You could also use the Advanced mode of tFilterRow and have your java code filter out the NULL records.

Best regards

Sabrina