Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@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 -
@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 -
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.
E