Visit the official Paxata Documentation portal for all of your doc needs.

Complex, Compound Filters

I need to filter my dataset to rows that have compound filter requirements.

For example, I want to find Sponsors who have each of these words in their name: "FUNDS", "INTERNATIONAL" and "LLC".  How do I set up such a filter.

The easiest (but not the only) way to do this is to create a computed column.  Here is the syntax:
AND(FIND("FUNDS",@[email protected] )>0,  FIND("INTERNATIONAL",@[email protected] )>0,  FIND("LLC",@[email protected] )>0)

Once you have this field computed, use a filter on the computed column to isolate those rows that meet the complex condition.
Sign In or Register to comment.