Data Shuttle Filter using multiple "does not contain" filters
I am trying to filter out a series of market lines from my Smartsheet that contains dozens of markets using a does not contain logic pathway. Right now i am using the following, but it allows in all the markets.
I do not want to use the contains logic since i sometimes get unique identifiers that I want to get in.
Is this an AND OR mix up?
All the market names are copied from sourcing files, so no typos, no capitalization, no spaces
Best Answer
-
Yup - I agree with what you're thinking: this is the difference between AND and OR. Consider something with MemberMarket "Houston." That row's MemberMarket does not contain "Northeast Florida" so even though you think it's filtered out by your #1, it's filtered right back IN with #2. If you change your filter logic, you'll probably see considerably different results from the Shuttle.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
Yup - I agree with what you're thinking: this is the difference between AND and OR. Consider something with MemberMarket "Houston." That row's MemberMarket does not contain "Northeast Florida" so even though you think it's filtered out by your #1, it's filtered right back IN with #2. If you change your filter logic, you'll probably see considerably different results from the Shuttle.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
I got it to work as (1) AND 2 AND 3 AND 4 AND 5 AND 6 AND 7. Probably would work without the parentheses. thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives