Any Function to check the one field in Present in the List of the fields?

Mahulima

For example I have a column where I have Value like this

If I use function contains then I am getting this true for all of the above scenario, but I want only row 1 should be true and rest should be false when the entire string is not matching. Can this be done?

Josh Boxer

The value 'XX,YY,ZZ' is a list and there are a load of List Functions that are really powerful and under utilized:

https://docs.experianaperture.io/data-quality/hosted-aperture-data-studio/data-studio-objects/functions/#list-transformation~native-functions 'List-Intersection' is one option