Reference Updated April 8, 2026

NEQ (!=)

Category: Logical functions

Overview

Description

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

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

Syntax

  • `NEQ('Node1', 'Node2')`

  • 'Node1' != 'Node2'

Parameters

  • Node1: First input node, specified using the node name in single quotes (e.g. 'Profit').

  • Node2: Second input node.


Examples

Checking whether matching rows are different

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

YearValue
2025400
2026700
2027850
2028500

Input node: B

YearValue
2025350
2026400
2027850
2028600

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

Year→ NEQ Result
20251
20261
20270
20281

FunctionWhen to use instead
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.
Was this page helpful?