Reference Updated April 8, 2026

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

  • EQ('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 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

YearValue
2025350
2026700
2027850
2028500

Input node: B

YearValue
2025350
2026400
2027850
2028600

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

Year→ EQ Result
20251
20260
20271
20280

FunctionWhen to use instead…
NEQ (!=)When you want to mark mismatches instead of matching values 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 equality.
Was this page helpful?