EQ (=)
Category: Logical functions
Overview
Description | Compares the rows of two inputs and returns true (1) if the values are equal and false (0) otherwise. Use when you need a 1/0 flag to mark matching values between two inputs. |
|---|---|
Syntax |
|
Parameters |
|
Examples
Checking whether matching rows are equal
This example compares two input nodes row by row. The result returns 1 where both values are equal and 0 where they differ.
Input node: A
Year | Value |
|---|---|
2025 | 350 |
2026 | 700 |
2027 | 850 |
2028 | 500 |
Input node: B
Year | Value |
|---|---|
2025 | 350 |
2026 | 400 |
2027 | 850 |
2028 | 600 |
Formula: EQ('A', 'B')
Year | → EQ Result |
|---|---|
2025 | 1 |
2026 | 0 |
2027 | 1 |
2028 | 0 |
Related Functions
Function | When to use instead… |
|---|---|
When you want to mark mismatches instead of matching values 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 equality. |