Tfilter advanced mode - java.lang.NullPointerException

[rwnetwork]

Hi all,

I've officially hit the point where I don't have any more ideas in trying to figure my tfilter advanced mode syntax and looking to the community to help me out in getting this accurate.

I have 3 conditions that are working fine, however, I learned that I have to add more.

My current conditions are this:

(input_row.FROMNAME != null ) || (input_row.TONAME != null ) || !(input_row.DESCRIPTION.isEmpty())

Therefore, I'm accurately filtering out the nulls for FROMNAME and TONAME and then blanks for DESCRIPTION.

Here is my job design, it does have a tExtractJSON component that a colleague worked on for this job.

https://www.screencast.com/t/7By21UZ9Jhlr

I have 3 rows left in my data set that I have to also filter out.  The snapshot link below are the 3 rows that have to be filtered out.

https://www.screencast.com/t/hiBDnSxI

I tried adding more conditions to my existing tfilter advanced mode, but I'm getting the good ol' ...' java.lang.NullPointerException' error.  All indications show that the FROMNAME and TONAME are blank strings.  

Can anyone provide the java syntax to remove these 3 rows? 

Or provide any more suggestions on additional steps to take to make sure that my FROMMANE and TONAME values are blank strings?

Please anyone help to shed any light that you can so I can get on with my life.  ha!

Thanks much!

Michelle

[rwnetwork]

In the raw data, it appears to be empty.

[Anonymous]

Hi,

   Please use the below sample condition to verify the data.

Relational.ISNULL(row8.columnValue) ? "null value" :row8.columnValue.equals("")? "empty string": row8.columnValue 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved