NOT_EQUALS

Syntax

NOT_EQUALS(<any>;<any>)

Description

Checks to see if two values are different by comparing the arguments of one column with the arguments of another column. Both columns must contain the same data type. NOT_EQUALS then returns a Boolean value, either true if both arguments are different or false if the arguments are equal. If one of the arguments is null, NOT_EQUALS returns true.

Examples

Data field type	Column1	Column2	NOT_EQUALS returns
Integer	15	35	true
Integer	23	23	false
Integer	23	null	true
Float	7.6	7.6	false
Float	8.6	15.3	true
Float	15.3	null	true
Date	Aug 2, 2011 3:55:03 PM	Oct 15, 2010 4:34:34 AM	true
Date	Mar 2, 2002 1:24:12 PM	Mar 2, 2002 1:24:12 PM	false
Date	null	Oct 15, 2010 4:34:34 AM	true
Boolean	false	true	true
Boolean	true	true	false
Boolean	null	true	true
String	Germany	George	true
String	George	George	false
String	German	null	true
	null	null	false

Instead of using a function, you could also use the equality operator !=.

Datameer X v11

NOT_EQUALS

Analytics

Syntax

Description

Examples

Related content