Computes the index at which a specified element is first found within an array. Indexing is left to right.

Array literal reference example:

arrayindexof(["A","B","C","D"],"C")

Output: Returns the index of the element "C" in the array, which is 2 in an 0-based index

Column reference example:

arrayindexof([myValues],myElement)


Output:
 Returns the index in the myValues arrays for the elements listed in the myElement column.

arrayindexof(array_ref,my_element)


ArgumentRequired?Data TypeDescription
array_refYarray or stringName of Array column, Array literal, or function returning an Array to apply to the function
my_elementYanyThe element to locate in the array

array_ref

Name of the array column, array literal, or function returning an array whose element you want to locate.

 

Required?Data TypeExample Value
YesString (column reference or function) or array literalmyArray1

my_element

Element literal that you wish to locate in the array. It can be a value of any data type.

 

Required?Data TypeExample Value
YesAny"1st"

Example - Computing points based on position of finish