Hello, i want to create a custom fitler on a look, and exclude rows that contain a list of strings in their name.
for example i want to exclude any rows that have “yas”,"lwl","part" in their name.
in sql i would do select …. where name not in (“yas”,"lwl","part")
in looker ive found contains, but works only with one string not with multiple.
I also have 2 more requirments: