OR (||)

OR('Node1', 'Node2')

'Node1' || 'Node2'

The OR function connects two inputs with the logical OR and returns true (1) if at least one of the values is true and false (0) otherwise.

Use this function when you need a 1/0 flag that becomes true as soon as at least one of two inputs is true.

Parameters

Node1Node referenceRequired: First input node, specified using the node name in single quotes (e.g. 'Profit').
Node2Node referenceRequired: Second input node.

A row that exists in only one of the two inputs is still evaluated. The missing side counts as false, so such a row returns 1 if the value that is there is non-zero and 0 otherwise. The row is never dropped, and the result covers every row of both inputs together.

This example shows that OR returns 1 when at least one of the two inputs is true. Non-zero values are treated as true, while 0 is treated as false.

Input node: 'A'

Input node: 'B'

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

AND (&&): When both inputs must be true at the same time instead of just one of them.
XOR: When exactly one of the two inputs should be true instead of allowing both to be true.