topic Re: Filtering out rows without any entry in a specific coloum (using Filters in tmap) in Talend Studio

Filtering out rows without any entry in a specific coloum (using Filters in tmap)

Moro — Tue, 27 Sep 2022 18:47:33 GMT

Hallo!

I have been trying to filter out whole rows of a table when there is en entry in a specific coloum (A) missing:

A B C D

23 Ireland bulk port

Ireland rubber port

23 Ireland stone airport

to be filtered like:

out3:

A B C D

23 Ireland bulk port

23 Ireland stone airport

out1:

A B C D

Ireland rubber port

As you can see in the screenshot I tried filtering by using the following expression and others - none worked:

"row1.location_id != null"

"row1.location_id = null" (trying the other way around)

"".equals(row1.location_id)

Could you let me know where the mistake lies? Thank you very much!

Mara

Anonymous — Wed, 28 Sep 2022 01:55:34 GMT

For out3, try the expression like this:

row1.location_id!=null||!row1.location_id.equals("")

for out1, set the 'catcher output reject' property as true.

Regards

Shong

Moro — Wed, 28 Sep 2022 08:30:05 GMT

Hi shong,

thanks a lot for you answer.

I tried your suggestion and got the meassage

"java.lang.NullPointerException: Cannot incoke "String.equals(Object)" because "row1.location_id" is null

Any idea how to fix that?

Thank you!

Anonymous — Wed, 28 Sep 2022 09:01:09 GMT

if row1.location_id is null value, just use this expression:

row1.location_id!=null

Let me know what's the result you are getting.

Regards

Shong

Moro — Thu, 29 Sep 2022 09:57:20 GMT

Hi Shong,

it worked! Thank you!