topic tFilterRow and Boolean values in Talend Studio

tFilterRow and Boolean values

EMeany — Wed, 27 Jun 2018 19:53:53 GMT

Hello,

I am trying to use tFilterRow to exclude rows where a Boolean column (isName) is False. The GUI does not seem to support Boolean relational so I am attempting to use the Advanced mode. I have tried the following lines in the Advanced editor without success:

input_row.isName.compareTo(true)

input_row.isName == true

input_row.isName.equals(true)

While testing the issue, i noticed that using:

Relational.ISNULL(input_row.isName)? true:input_row.isName.equals(true)

Gives me half the output I want (I get the filter output (value is true) but not the reject output (value is false))

What am I doing wrong here?

Thank you in advance!

Re: tFilterRow and Boolean values

iamabhishek — Thu, 28 Jun 2018 08:16:25 GMT

@EMeany - I just tried to re-pro your use case like below and was able to filter out records. Let me know if this is what you are trying to achieve.

Job Layout -

I have two fields as input (isName is defined as bool). Configured tFilterRow like below -

And as you could see the output below the rows are filtered accordingly -

Re: tFilterRow and Boolean values

EMeany — Tue, 10 Jul 2018 15:20:46 GMT

@iamabhishek,

Thank you for your reply. For my particular use case I was not able to use the method you suggested (due to a null pointer error). However, I was able to reproduce your job results and have confirmed that tFilterRow works as you suggest.

Thank you again for your help.