Exploratory Community

How to detect multiple conditions at once for "contain / not contain" filter operator

#1

Suppose you have Investors column in your Unicorn Companies Data and want to exclude rows that contain Google, Soft, and Partner in Investors’ name.

To do so, you can use “|” and connect these conditions like Google|Soft|Partner:

This will remove all rows whose investor name contains either, Google, Soft, or Partner.