EQ (=)

In Logical functions

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

Use this function when you need a 1/0 flag to mark matching 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.

Example

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'

Input node: 'B'

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

See also

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.