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

[Moro]

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]

Hi

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]

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 · Accepted solution]

Hi

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]

Hi Shong,

it worked! Thank you!