topic Re: How to manage null value with tFilter in Talend Studio

How to manage null value with tFilter

Mayot — Fri, 20 Jul 2018 08:10:29 GMT

Hi, I have a problem handling null values in my tFilter.

My tFilter condition :

( input_row.COMPANY_CODE.equals("31") || input_row.COMPANY_CODE.equals("14") )  && !(input_row.DESCRIPTION.equals("SUB-TOTAL :")) && !(input_row.DESCRIPTION.equals("TOTAL :"))

I have this error ODS_BALANCE_CSV_TEMP - tFilterRow_3 null

there're null values in the columns of the table that I'm trying to filter. Before I had a classic filter but since I need to combine the conditions OR and AND, I have to do it in java.

How to overcome this problem?

Thank you

Re: How to manage null value with tFilter

Anonymous — Fri, 20 Jul 2018 08:43:44 GMT

Hi,

You will have to assign either true or false for the null condition by catching them. Please see the screen shot below for a simple example.

Here, if the input data is coming as null, then we are converting it into either true or false based on the condition. You will have to do null check condition before going to equal condition clause. Then it will work fine.

If you think the suggestion given has helped you, please mark it as acceptable solution.

Warm Regards,

Nikhil Thampi

Re: How to manage null value with tFilter

iamabhishek — Fri, 20 Jul 2018 08:45:21 GMT

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

Re: How to manage null value with tFilter

Mayot — Fri, 20 Jul 2018 09:27:23 GMT

Thanks for you explanation

Re: How to manage null value with tFilter

Mayot — Fri, 20 Jul 2018 09:28:09 GMT

Thanks, it works fine

Re: How to manage null value with tFilter

Anonymous — Fri, 20 Dec 2019 15:33:13 GMT

Nikhil,

I tried your syntax for passing through a null field and asking for a filter. I wrote it like this

(Relational.ISNULL(input_row.Reason_Code)?true:false) && !input_row.Reason_Code.equals("334"))

It's still providing a null pointer exception. Do you know what the issue could be?

Re: How to manage null value with tFilter

Anonymous — Fri, 20 Dec 2019 16:59:33 GMT

Nevermind I figured it out. I had the parenthesis in wrong spots