ARRAY_CONTAINS_ANY

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Checks whether there's any overlap between two arrays.

  • <array1>: The first array to compare.
  • <array2>: The second array to compare.

Returns a boolean value (true or false) that indicates whether any element exists in both arrays.

  • Both arrays must have compatible element types.
  • Returns false if either array is empty.

Check whether two arrays share any common elements.

Returns true because both arrays contain the value 2.