Comparing Arrays
- Updated2026-08-28
- 1 minute(s) read
You can use Comparison functions to compare either the individual elements of arrays or entire arrays as one object.
Some Comparison functions have two modes for comparing arrays. In Compare Aggregates mode, the function returns a single Boolean value. In Compare Elements mode, the function compares the elements individually and returns an array of Boolean values.
In Compare Aggregates mode, the string comparison and array comparison operations follow exactly the same process—the Comparison function treats the string as an array of ASCII characters.
Note The Max
& Min function behaves differently than other comparison functions. The Max & Min
function returns either the maximum element or array or the minimum element or array,
depending on which mode you specify and which output you specify.