Filter string based on multiple contains

Hey,

I’m currently building a explore which contains a concatenated string as a key. I would like to be able to filter based on this string where I have 2-4 unique substrings that it must contain. This would equate to an AND contains while I can only seem to make OR contains filters.

The sql equivalent of what I was to achieve looks a little like this:

WHERE (key_string LIKE ‘SUBSTRING_1’ AND key_String LIKE ‘SUBSTRING_2’)

1 2 830
2 REPLIES 2
Top Labels in this Space