KNOWLEDGE BASE

Set Multiple OR Filters in Tableau Prep


Published: 06 Apr 2021
Last Modified Date: 06 Apr 2021

Question

How to set multiple OR conditions filters in wildcard filtering in Tableau Prep Builder?

For now, only one condition could be set in wildcard match filtering.
User-added image

Environment

  • Tableau Prep Builder

Answer

Create a calculation field to set the OR conditions. Please check the below example and attached Flow File.
User-added image

1. Include Filter


STARTSWITH([Ease of Business (clusters)],'Fri')
OR
STARTSWITH([Ease of Business (clusters)],'Lo')

2. Exclude Filter

(STARTSWITH([Ease of Business (clusters)],'Fri')
OR
STARTSWITH([Ease of Business (clusters)],'Lo')
)=FALSE
Did this article resolve the issue?