NEQ (!=)

NEQ('Node1', 'Node2')

'Node1' != 'Node2'

The NEQ function compares the rows of two inputs and returns true (1) if the values are not equal and false (0) otherwise.

Use this function when you need a 1/0 flag to mark mismatching values between two inputs.

Parameters

Node1Node referenceRequired: First input node, specified using the node name in single quotes (e.g. 'Profit').
Node2Node referenceRequired: Second input node.

A row that exists in only one of the two inputs is still compared. The missing side counts as 0, so the row comes back as 1 unless the value that is there is also 0. Nothing is dropped.
Because of that, a gap and a genuine mismatch look identical in the result. If you use NEQ to reconcile two nodes, check first that both cover the same rows, for example with FINDMISSING.

This example compares two input nodes row by row. The result returns 1 where the values differ and 0 where they are equal.

Input node: 'A'

Input node: 'B'

Formula: NEQ('A', 'B')

EQ (=): When you want to mark matching values instead of mismatches between two inputs.
GT (>): When you need to check whether one input is greater than another instead of checking for equality.
LT (<): When you need to check whether one input is less than another instead of checking for inequality.