The operator != is undefined for the argument type(s) boolean, null

Highlighted
One Star

The operator != is undefined for the argument type(s) boolean, null

Hi,
I get the following error when compiling and running my job;
The operator != is undefined for the argument type(s) boolean, null
The job uses a tMap which sends the output to a tStewardshipTaskOutput. Attached my job.
I try to find the solution to this, but need some help.

NL_DQ_AccountMatching.zip.zip
Moderator

Re: The operator != is undefined for the argument type(s) boolean, null

Hi,
From your job, we have seen that you used row5.GRP_SIZE>1||!row5.MASTER in filter expression of filter Matched Row(tMap2).
row5.MASTER is boolean data type.
Do you mean row5.MASTER==false?
What's your requirement about this filter? Could you please give us more description about it?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: The operator != is undefined for the argument type(s) boolean, null

I still have the same issue. When I start this job, i get:
The operator != is undefined for the argument type(s) boolean, null

If I remove the boolean columns from row2, the job works fine.

NL_DQ_Account_Deduplication.zip.zip
One Star

Re: The operator != is undefined for the argument type(s) boolean, null

yes
Moderator

Re: The operator != is undefined for the argument type(s) boolean, null

Hi vishnu.swetha,
The operators like "!=" does not work for the Java data type long. Please show us your tfilterrow component setting screenshot which will be helpful for us to address your issue.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.