The ArrayContains function determines if a specific value is in a list or array; returns True if found, or False otherwise.

Syntax

ArrayContains(list, target)

The ArrayContains function has the following arguments:

list
Required
A column that contains the list or array that Sigma searches for a match
target
Required
The value to match

The argument must reference a list parameter or a column that contains list values. When the target argument references a column, the column must contain text values. Other data value types result in an invalid formula.

Examples

A table contains an Array column that returns list values from the Product Type PRM list parameter. You can use the ArrayContains function to search the Array column list for the value in the Product Type column.

ArrayContains([Array], [Product Type])

You can also use the function to determine whether or not the value in the Product Type column is currently selected in the Product-Type-PRM list parameter.

ArrayContains([Product-Type-PRM], [Product Type])

When the value in the Product Type column is found in the Array column or Product Type PRM list parameter, the function output is True. If the value is not found, the function output is False.

mceclip2.png

Related functions


Was this page helpful?
Yes No