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

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

Anonymous — Tue, 07 Jul 2015 11:54:10 GMT

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

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

Anonymous — Wed, 08 Jul 2015 09:00:18 GMT

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

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

Anonymous — Fri, 18 Sep 2015 10:33:56 GMT

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

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

Anonymous — Wed, 08 Feb 2017 18:31:22 GMT

yes

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

Anonymous — Thu, 09 Feb 2017 11:39:13 GMT

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