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 |
|
Parameters |
|
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
Year | Value |
|---|---|
2025 | 400 |
2026 | 700 |
2027 | 850 |
2028 | 500 |
Input node: B
Year | Value |
|---|---|
2025 | 350 |
2026 | 400 |
2027 | 850 |
2028 | 600 |
Formula: NEQ('A', 'B')
Year | → NEQ Result |
|---|---|
2025 | 1 |
2026 | 1 |
2027 | 0 |
2028 | 1 |
Related Functions
Function | When to use instead |
|---|---|
When you want to mark matching values instead of mismatches between two inputs. | |
When you need to check whether one input is greater than another instead of checking for equality. | |
When you need to check whether one input is less than another instead of checking for inequality. |