How to check if element is present in array

[dheerajkhatri]

I want to perform something like this - ARRAY_CONTAINS(["1","2","3","4"], value)
and then evaluate the expression by passing value? Is there existing functionality which can be used or I've to write function for this? @uklimaschewski @stevenylai

Thanks in Advance.

[uklimaschewski]

Hi, there is no such function. Implementing it should be straight forward. It would be nice to have this and some other basic array functions in the standard.

[stevenylai]

Sorry for the late reply. Yes, I would also agree that it's nice to have this in the standard library. Python pandas has the 'isin' function. SQL also has the IN operator so this is a common use case for scientific calculation / data manipulation.