ArrayContains
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.